Share via


NotificationMethod Property

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: