Online Documentation for SQL Administrator for SQL Server

Managing notifications


The Notifications tab allows you to specify actions that the SQL Server Agent service will take after the job completes (succeeds or fails). Job responses ensure that database administrators know when jobs complete and how frequently they run.

 

Job Editor - Managing notifications

 

 

Notify by e-mail

Use the drop-down list to select the operator that will be notified via e-mail, and specify the job status for the notification to be performed:

!CheckBox When the job succeeded and/or

!CheckBox When the job failed

 

Notify by pager

Use the drop-down list to select the operator that will be notified using electronic paging, and specify the job status for the notification to be performed:

!CheckBox When the job succeeded and/or

!CheckBox When the job failed

 

Notify by net send

Use the drop-down list to select the operator that will be notified using a net send message, and specify the job status for the notification to be performed:

!CheckBox When the job succeeded and/or

!CheckBox When the job failed

 

Write to Windows Application event log

If necessary, specify the job status for writing to Microsoft Windows Application event log:

!CheckBox When the job succeeded and/or

!CheckBox When the job failed

 

Delete the job

If you are certain that you do not need to rerun this job later, you can specify the job status deleting the job:

!CheckBox When the job succeeded and/or

!CheckBox When the job failed