Skip to content

Latest commit

 

History

History
38 lines (27 loc) · 2.27 KB

notify-operator-task.md

File metadata and controls

38 lines (27 loc) · 2.27 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords
Notify Operator Task
Notify Operator Task
chugugrace
chugu
03/14/2017
sql
integration-services
conceptual
sql13.dts.designer.notifyoperatortask.f1
Notify Operator task
notifications [Integration Services]
SQL Server Agent [Integration Services]

Notify Operator Task

[!INCLUDEsqlserver-ssis]

The Notify Operator task sends notification messages to [!INCLUDEssNoVersion] Agent operators. A [!INCLUDEssNoVersion] Agent operator is an alias for a person or group that can receive electronic notifications. For more information about [!INCLUDEssNoVersion] operators, see 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.

Configuration of the Notify Operator Task

You can set properties through [!INCLUDEssIS] Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in [!INCLUDEssIS] Designer.

For more information about the properties that you can set in [!INCLUDEssIS] Designer, click the following topic:

For more information about how to set these properties in [!INCLUDEssIS] Designer, click the following topic: