Share via


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.