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.