Export (0) Print
Expand All

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 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 do not need to rerun this job.

Community Additions

ADD
Show:
© 2014 Microsoft