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.
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: