Specifying Job Responses

Job responses specify actions that the SQL Server Agent service will take after a job completes. Job responses ensure that database administrators know when jobs complete and how frequently they run. 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 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 do not need to rerun this job.