Export (0) Print
Expand All
Expand Minimize

EnumJobNotifications Method

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.

The EnumJobNotifications method returns a QueryResults object that enumerates notifications made by Microsoft SQL Server Agent on completion of job execution.

object.EnumJobNotifications as QueryResults

object

Expression that evaluates to an object in the Applies To list.

HRESULT EnumJobNotifications(
LPSQLDMOQUERYRESULTS *ppResults);

The EnumJobNotifications method returns a QueryResults object that contains one result set defined by these columns.

Column name

Data type

Description

job_id

uniqueidentifier

System-generated identifier for a SQL Server Agent job.

name

nvarchar(129)

Job name.

notify_level_email

integer

Job completion status causing notification by e-mail. Interpret as described in Remarks.

notify_level_/netsend

integer

Job completion status causing notification by network pop-up 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 using these values.

Value

Description

0

Operator not configured for notification by notification method.

1

Operator receives notification of a successful job execution.

2

Operator receives notification of an unsuccessful execution attempt.

3

Operator receives notification regardless of 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft