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.