Online Documentation for SQL Administrator for SQL Server

Notify operator


Use the Notify Operators Task dialog to add an automatic notification to this maintenance plan. To use this task you must have Database Mail enabled and properly configured with msdb as a Mail Host Database, and have a Microsoft SQL Server Agent operator with a valid e-mail address.

The General tab allows you to set common properties for this task. To set relationships between tasks use the Precedence constraints tab.

 

Maintenance plans - Maintenance Plan Editor - Managing tasks - Notify operator

 

 

Name

Enter the task name.

 

Enabled

Check this option to enable task execution.

 

Connection

Specify which server connection should be used for task execution. You can choose among existing connections or create a new one.

 

Operators to notify

Specify the recipient of the e-mail. Check the operator from the list of available operators.

 

Message subject

Specify the text to include in the notification message subject line.

 

Message text

Enter the text to include in the notification message body.

 

 


See also:

Backup database

Check database

Rebuild indexes

Reorganize indexes

Shrink database

Update statistics

Execute job

Execute T-SQL statement

Clean up history

Clean up maintenance log

Precedence constraints