If you have the workspace that does the translation you can use that in an Automation: start with a FME Form Schedule trigger and then add a Run Workspace action

If I want to add translation which one need to use?

Can you explain what you are trying to do?

I have each day with date stamp CSV file data, I need to upload SQL Server via FME, what transformer I need to use in order to pick up new CSV file data automatically from  folder and load to SQL server via FME.

Does the CSV filename contain the date or is it always the same filename?

CSV filename contain the date of each day 

and each day their is new file with each day date.

Right, so use a Creator and a DateTimeStamper to get the current date (DateTimeConverter if you need to format it in a specific way), then FeatureReader to read csv and construct the filename with that timestamp.

same file name with everyday data stamp

Yes, so you need to construct the final filename in the text editor of the FeatureReader. E.g. filename_@Value(date).csv where date is your date attribute.