• Article

Notify Operator Task

The Notify Operator task sends notification messages to SQL Server Agent operators. A SQL Server Agent operator is an alias for a person or group that can receive electronic notifications. For more information about SQL Server operators, see Defining Operatorsand Viewing and Modifying Operators.

By using the Notify Operator task, a package can notify one or more operators via e-mail, pager, or net send. Each operator can be notified by different methods. For example, OperatorA is notified by e-mail and pager, and OperatorB is notified by pager and net send. The operators who receive notifications from the task must be members of the OperatorNotify collection on the Notify Operator task.

The Notify Operator task is the only database maintenance task that does not encapsulate a Transact-SQL statement or a DBCC command.

Configuring the Notify Operator Task

You can set properties through SSIS Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in SSIS Designer.

For more information about the properties that you can set in SSIS Designer, click the following topic:

For more information about how to set these properties in SSIS Designer, click the following topic:

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.