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.