NotificationMethod Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The NotificationMethod property specifies the method used when notifying a fail-safe operator of a raised alert.
Синтаксис
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. |
Замечания
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.