UpdateNotification Method (SQL-DMO)

The UpdateNotification method configures SQL Server Agent operator notification for alerts raised.

Applies To

Syntax

object.UpdateNotification( AlertOrOperator , NotificationType )

Part	Description
object	Expression that evaluates to an object in the Applies To list
AlertOrOperator	String specifying a SQL Server Agent alert or operator by name as described in Settings
NotificationType	Long integer specifying a notification method as described in Settings

Settings

When setting the AlertOrOperator argument of the UpdateNotification method of the Alert object, the string identifies an existing operator by name. When setting the argument for the Operator object method, the string identifies an existing alert by name.

Set NotificationType by using these values.

Constant	Value	Description
SQLDMONotify_All	7	Notify using e-mail, e-mail sent to the pager address, and network popup message.
SQLDMONotify_Email	1	Notify by e-mail sent to the operator e-mail address.
SQLDMONotify_NetSend	4	Notify by network popup message posted to the operator network address.
SQLDMONotify_None	0	Do not notify the operator.
SQLDMONotify_Pager	2	Notify by e-mail sent to the operator pager address.

Remarks

The AddNotification method associates operators with alerts. Operators designated receive notification messages when an event raising an alert occurs. When an alert is raised, notification can be sent using e-mail, network popup message, or pager. The AddNotification method allows specification of one or more notification mechanisms when operators are assigned notification for an alert.

The RemoveNotification method removes all operator notification mechanisms for an alert. Use the UpdateNotification method to alter the notification mechanism without dropping the association between an alert and operator.

Prototype (C/C++)