Export (0) Print
Expand All

Specifying Job Responses

SQL Server 2000

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

Enterprise Manager

Transact-SQL

SQL-DMO

To write the job status to the Windows application log

Enterprise Manager

Transact-SQL

SQL-DMO

To automatically delete a job

Enterprise Manager

Transact-SQL

SQL-DMO

To set the polling interval for target servers

Enterprise Manager

Transact-SQL

SQL-DMO

Show:
© 2014 Microsoft