How to create a batch file?

Question

How to Creating Batch File to execute the job manually. to execute complete process automatically similarly like the automated process does

Ehtesham · Answer

Are you referring to .bat file? .bat file executes dos commands open notepad type your commands and save it as yourfilename.bat when you execute the said file its going to execute all your commands which are written in .bat file

Senthilkumar · Answer

Hi Sql server provides you to config the jobs which can execute on the scheduled time. Please refer this article: http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express