2

I am writing PowerShell scripts to control SQL Server agent start/stop to ensure all the contained jobs runs according to defined schedule. I want to make sure that the only thing I need to do is to start the SQL Server Agent Windows Service, and then all the contained SQL Server Jobs will run automatically according to defined schedule? No need to control each job's start/stop specifically?

I am using SQL Server 2008 on Windows Server 2003.

thanks in advance, George

George2
  • 44,761
  • 110
  • 317
  • 455

1 Answers1

6

When you start SQL Server Agent all jobs (if they are not disabled) will run automatically and it's no need to control each job. Just make sure that jobs are enabled.

Sergey Olontsev
  • 1,084
  • 7
  • 19
  • Thanks HawX, do you have any documents to claim it? I have tested you are correct, and I want to read more to get more picture. – George2 Aug 01 '09 at 13:33
  • 1
    "Note: SQL Server Agent must be running before local or multiserver administrative jobs can run automatically." - quote from MSDN. You can read more about SQL Server Agent here: http://msdn.microsoft.com/en-us/library/ms189237.aspx – Sergey Olontsev Aug 01 '09 at 13:55
  • 1
    Agreed. That's how we run all of our database backups at our office. – karlgrz Aug 02 '09 at 02:25