How to notify an operator of job status (Enterprise Manager)

How to Install SQL Server 2000

How To

How to notify an operator of job status (Enterprise Manager)

To notify an operator of job status

  1. In the details pane, right-click the job, and then click Properties.

  2. In the Job Properties dialog box, click the Notifications tab.

  3. If you want to notify an operator by e-mail, select the E-mail operator check box, and then in the list do one of the following:
    • Click When the job succeeds to notify the operator when the job completes successfully.

    • Click When the job fails to notify the operator when the job completes unsuccessfully.

    • Click Whenever the job completes to notify the operator regardless of completion status.
  4. If you want to notify an operator by pager, select the Page operator check box, and then in the list do one of the following:
    • Click When the job succeeds to notify the operator when the job completes successfully.

    • Click When the job fails to notify the operator when the job completes unsuccessfully.

    • Click Whenever the job completes to notify the operator regardless of completion status.
  5. If you want to notify an operator by net send, select the Net send operator check box, click an operator, and then do one of the following:
    • Click When the job succeeds to notify the operator when the job completes successfully.

    • Click When the job fails to notify the operator when the job completes unsuccessfully.

    • Click Whenever the job completes to notify the operator regardless of completion status.