Database Job
The metrics in this category return information about jobs that are used by the SQLServerAgent service to perform automated activities in Microsoft SQL Server.
Default Collection Interval — Every 2 hours
Table 2-28 Database Job Metrics
Metric | Description and User Action |
---|---|
Computer Used to Send Network Messages |
Name of the user or computer used when sending network messages. |
Computer Used to Send Pages |
Name of the user or computer used when sending a page. |
Current Execution Status |
|
Current Execution Steps in the Job |
Current job execution step. |
Current Retry Attempt |
If the job is running and the step has been retried, this is the current retry attempt. |
Delete Job Event |
Bitmask indicating under what circumstances the job should be deleted when a job completes. Possible values are the same as for notify_level_eventlog. |
Description |
Description for the job. |
Email of Operator |
Email name of the operator to notify. |
Enabled |
Indicates whether the job is enabled to be executed. |
ID of Next Run Schedule |
Identification number of the next run schedule. |
Job Category |
The category to which the job belongs. |
Job Creation Date |
Date the job was created. |
Job ID (key column) |
Job identification number. |
Job Modification Date |
Date the job was last modified. |
Job Owner |
The owner of the job. |
Job Type |
|
Job Version Number |
Version of the job, which is automatically updated each time the job is modified. |
Last Run Date (mm-dd-yyyy) |
Date the job last started executing. |
Last Run Outcome |
Outcome of the job the last time it ran:
|
Last Run Time (hh:mm:ss) |
Time the job last started executing. |
Name |
Name of the job. |
Next Run Date (mm-dd-yyyy) |
Date the job is next scheduled to run. |
Next Run Time (hh:mm:ss) |
Time the job is next scheduled to run. |
Notify Level Email |
Bitmask indicating under what circumstances a notification email should be sent when a job completes. Possible values are the same as for notify_level_eventlog. |
Notify Level Event Log |
Bitmask indicating under what circumstances a notification event should be logged to the Microsoft Windows NT application log. Possible values:
|
Notify Level Net Send |
Bitmask indicating under what circumstances a network message should be sent when a job completes. Possible values are the same as for notify_level_eventlog. |
Notify Level Page |
Bitmask indicating under what circumstances a page should be sent when a job completes. Possible values are the same as for notify_level_eventlog. |
Number of Job Schedules |
Number of job schedules the job has. |
Number of Job Steps |
Number of job steps the job has. |
Number of Target Servers |
Number of target servers the job has. |
Originating Server |
Name of the server from which the job originated. |
Start Step ID |
ID of the step in the job where execution should begin. |