O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQL Server Agent

SQL Server Agent is the driving force behind database automation. It is responsible for processing alerts and running scheduled jobs. When alerts are triggered and when scheduled jobs fail, succeed, or complete, you can notify SQL Server operators. Operator notifications are also processed through SQL Server Agent.

Accessing Alerts, Operators, and Jobs

You can use SQL Server Management Studio to access resources related to SQL Server Agent by completing the following steps:

  1. Start SQL Server Management Studio. In Object Explorer view, connect to the server instance of your choice, and then expand the server’s SQL Server Agent folder. (The SQL Server Agent must be running to expand the related node.)

  2. You should see entries for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required