SQL Server Agent, Jobs object
Applies to: 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. |
Related content
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin