How to: Notify an Operator of Job Status (SQL Server Management Studio)

This topic describes how to set notification options so Microsoft SQL Server Agent can send notifications to operators about jobs.

To notify an operator of job status

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, expand Jobs, right-click the job you want to edit, and select Properties.

  3. In the Job Properties dialog box, select the Notifications page.

  4. If you want to notify an operator by e-mail, check E-mail, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.
    • When the job fails to notify the operator when the job completes unsuccessfully.
    • When the job completes to notify the operator regardless of completion status.
  5. If you want to notify an operator by pager, check Page, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.
    • When the job fails to notify the operator when the job completes unsuccessfully.
    • When the job completes to notify the operator regardless of completion status.
  6. If you want to notify an operator by net send, check Net send, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.
    • When the job fails to notify the operator when the job completes unsuccessfully.
    • When the job completes to notify the operator regardless of completion status.

See Also

Tasks

How to: Configure SQL Server Agent Mail to Use SQL Mail (SQL Server Management Studio)
How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio)
How to: Set the Mail Profile for SQL Server Agent (SQL Server Management Studio)
How to: Create an Operator (SQL Server Management Studio)

Concepts

Implementing Jobs

Help and Information

Getting SQL Server 2005 Assistance