SQL Job Details Test
This test measures the status of all the jobs executing on an Microsoft SQL server. This test has been disabled by default. To enable this test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Microsoft SQL as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : A Microsoft SQL server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Microsoft SQL server monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Total SQL jobs |
Indicates the total number of jobs on the server during the last measurement period. |
Number |
This measure is the sum of Successful SQL jobs, Failed SQL job and Cancelled SQL jobs measures. |
Successful SQL jobs |
Indicates the jobs that have been successfully executed. |
Number |
|
Failed SQL jobs |
Indicates the jobs that have not been successfully executed. |
Number |
Ideally, the value for this measure should be zero. On other hand, if this measure reports a non-zero value, then you can use detailed diagnosis to identify the name of the job that has failed, the server name and the step at which the job failed. |
Cancelled SQL jobs |
Indicates the jobs that were terminated by user interference. |
Number |
Ideally, the value for this measure should be zero. However, if this measure reports a non-zero value, then you can use detailed diagnosis to identify the name of the job that has been cancelled, server name and the step at which the job was cancelled. |
Executing SQL jobs |
Indicates the number of jobs that are currently executing on the server. |
Number |