| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
SQL Server Agent, Jobs object |
Learn about the SQL Server Agent Jobs performance object, which contains performance counters that report information about SQL Server Agent jobs. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!INCLUDE SQL Server]
The SQL Server Agent Jobs performance object contains performance counters that report information about SQL Server Agent jobs. The table below lists the counters that this object contains.
The table below contains the SQLAgent:Jobs counters.
| Name | Description |
|---|---|
| Active Jobs | This counter reports the number of jobs currently running. |
| Failed jobs | This counter reports the number of jobs that exited with failure. |
| Job success rate | This counter reports the percentage of executed jobs that completed successfully. |
| Jobs activated/minute | This counter reports the number of jobs launched within the last minute. |
| Queued jobs | This counter reports the number of jobs that are ready for SQL Server Agent to run, but which have not yet started running. |
| Successful jobs | This counter reports the number of jobs that exited with success. |
Each counter in the object contains the following instances:
| Instance | Description |
|---|---|
| _Total | Information for all jobs. |
| Alerts | Information for jobs started by alerts. |
| Others | Information for jobs that were not started by alerts or schedules. Typically these are jobs started manually using sp_start_job. |
| Schedules | Information for jobs started by schedules. |