This topic has not yet been rated - Rate this topic

NotificationMethod Property

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 NotificationMethod property specifies the method used when notifying a fail-safe operator of a raised alert.

Syntax

object.NotificationMethod [= value]

Parts

object: An expression that evaluates to an object in the Applies To list.
value: A long integer that specifies an alert notification method as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetNotificationMethod(SQLDMO_NOTIFY_TYPE *pRetVal);
HRESULT SetNotificationMethod(SQLDMO_NOTIFY_TYPE NewValue);

Settings

Constant	Value	Description
SQLDMONotify_All	7	Notification is made by e-mail, e-mail is sent to the pager address and a network pop-up message is sent.
SQLDMONotify_Email	1	Notification is made by e-mail sent to the operator e-mail address.
SQLDMONotify_NetSend	4	Notification is made by network pop-up message posted to the operator network address.
SQLDMONotify_None	0	No notification method is specified for the referenced operator.
SQLDMONotify_Pager	2	Notification is made by e-mail sent to the operator pager address.

Remarks

The NotificationMethod property is a bit-packed long value. To specify more than a single notification method, combine enumerated values using an OR logical operator.

Applies To:

AlertSystem Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD