Specifying Job Responses

Administering SQL Server

Administering SQL Server

Specifying Job Responses

You can define job responses to occur after a job completes. Typical job responses include:

  • Notifying the operator by using e-mail, electronic paging, or a net send message.

    Use one of these job responses if the operator must perform a follow-up action. For example, if a backup job completes successfully, the operator must be notified to remove the backup tape and store it in a safe location.

  • Writing an event message to the Microsoft® Windows® application log.

    You can use this response only for failed jobs.

  • Automatically deleting the job.

    Use this job response if you are certain that you will not need to rerun this job.

To notify an operator of job status