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:
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.)
You should see entries for ...