SQL Server Agent, Jobs Object

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Implement Jobs
Use Performance Objects
Monitor Resource Usage (System Monitor)