EnumJobNotifications Method
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The EnumJobNotifications method returns a QueryResults object that enumerates notifications made by Microsoft SQL Server Agent on completion of job execution.
Syntax
object
.EnumJobNotifications
as
QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT EnumJobNotifications(
LPSQLDMOQUERYRESULTS *ppResults);
Returns
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. |
Hinweise
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.