Geek Answers Handbook

How to run SQL Server Agent jobs automatically

I am writing PowerShell scripts to control the start / stop of the SQL Server Agent so that all tasks run according to a specific schedule. I want to make sure that the only thing I need to do is start the Windows Agent service of SQL Server Agent, and then all the SQL Server jobs contained in it will be executed automatically according to a specific schedule? No need to control the start / stop of each job specifically?

I am using SQL Server 2008 on Windows Server 2003.

thanks in advance George

+2
source share
1 answer

When SQL Server Agent starts, all tasks (if they are not disabled) will start automatically, and there is no need to control each task. Just make sure the task is on.

+6
source

More articles:


All Articles