Notification Method Constants (SQLDMO_NOTIFY_TYPE)
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.
Notification method constants define a SQL Server Agent notification feature. Use notification method constants to control SQL Server Agent behaviors when notifying an operator of an alert condition.
Constant |
Value |
Description |
|---|---|---|
SQLDMONotify_All |
7 |
Notification is made by e-mail, e-mail sent to the pager address, and network pop-up message. |
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. |