The EnumJobNotifications method returns a QueryResults object enumerating notifications made by SQL Server Agent on completion of job execution.
object.EnumJobNotifications as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list. |
The EnumJobNotifications method returns a QueryResults object containing one result set defined by these columns.
| Column name | Data type | Description |
|---|---|---|
| job_id | unique identifier |
System-generated identifier for SQL Server Agent job |
| name | nvarchar(129) | Job name |
| notify_level_email | integer | Job completion status causing notification by email. Interpret as described in Remarks |
| notify_level_netsend | integer | Job completion status causing notification by network popup message. Interpret as described in Remarks |
| notify_level_page | integer | Job completion status causing notification by pager. Interpret as described in Remarks |
Interpret values returned in value returned in the notify_level_email, notify_level_netsend, and notify_level_page columns by using these values.
| Value | Description |
|---|---|
| 0 | Operator not configured for notification by notification method. |
| 1 | Operator receives notification on successful execution of job. |
| 2 | Operator receives notification on unsuccessful execution attempt. |
| 3 | Operator receives notification regardless execution outcome. |
The result set returned enumerates all jobs for which an operator will receive notification on execution attempt completion. At least one of the columns notify_level_email, notify_level_netsend, or notify_level_page will contain a non-zero value for all rows in the result set.
HRESULT EnumJobNotifications(
LPSQLDMOQUERYRESULTS *ppResults);