NotificationMethod Property
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa caratteristica in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The NotificationMethod property specifies the method used when notifying a fail-safe operator of a raised alert.
Sintassi
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. |
Osservazioni
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.