Administering SQL Server

Specifying Job Responses

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

To notify an operator of job status

Enterprise Manager

Enterprise Manager

Transact-SQL

SQL-DMO

To write the job status to the Windows application log

Enterprise Manager

Enterprise Manager

Transact-SQL

SQL-DMO

To automatically delete a job

Enterprise Manager

Enterprise Manager

Transact-SQL

SQL-DMO

To set the polling interval for target servers

Enterprise Manager

Enterprise Manager

Transact-SQL

SQL-DMO