From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Scheduling jobs with SQL Server Agent

Scheduling jobs with SQL Server Agent - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Scheduling jobs with SQL Server Agent

“

If you want to execute a package as a regularly scheduled occurrence there is a part of SQL Server that can do that for you but it's a part that's actually turned off when you first install it. In fact if I open up another instance of Management Studio, I'm going to connect to the database engine and you may have seen this before, that there is an entry here that says SQL Server Agent. You may have seen it in Management Studio or if you had opened up the Configuration Manager you would also see it there. SQL Server Agent is stopped by default and its Start Mode is Manual, which means when the machine is restarted it will not start itself. It's again because of what Microsoft tend to do these days, which is they ship products with only the necessary part of them turned on. Now SQL Server Agent isn't absolutely necessary so it's off by default and you have to turn it on if you want to use it. I can just turn it on quite easily from SQL Server Configuration Manager, just hit the little…

Contents