This topic has not yet been rated - Rate this topic

RemoveNotification Method

SQL Server 2008

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The RemoveNotification method drops all SQL Server Agent alert notification assignments for an operator.

Syntax

object.RemoveNotification(AlertOrOperatorName)

Parts

object: Expression that evaluates to an object in the Applies To list.
AlertOrOperatorName: String that identifies an existing alert or operator as described in Settings.

Prototype (C/C++)

HRESULT RemoveNotification(
SQLDMO_LPCSTR Value);

Settings

When setting the AlertOrOperator argument of the RemoveNotification 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.

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 pop-up message, or pager. The AddNotification method allows the 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 notification mechanism without dropping the association between an alert and operator.

Applies To:

Alert Object

Operator Object

Reference

AddNotification Method

UpdateNotification Method

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD