SQL Server Agent, JobSteps Object
The SQL Server Agent JobSteps performance object contains performance counters that report information about SQL Server Agent job steps. The table below lists the counters that this object contains.
The table below contains the SQLAgent:JobSteps counters.
Name |
Description |
|---|---|
Active steps |
This counter reports the number of job steps currently running. |
Queued steps |
This counter reports the number of job steps that are ready for SQL Server Agent to run, but which have not yet started running. |
Total step retries |
This counter reports the total number of times that Microsoft SQL Server has retried a job step since the last server restart. |
Each counter in the object contains the following instances:
Instance |
Description |
|---|---|
_Total |
Information for all job steps. |
ActiveScripting |
Information for job steps that use the ActiveScripting subsystem. |
ANALYSISCOMMAND |
Information for job steps that use the ANALYSISCOMMAND subsystem. |
ANALYSISQUERY |
Information for job steps that use the ANALYSISQUERY subsystem. |
CmdExec |
Information for job steps that use the CmdExec subsystem. |
Distribution |
Information for job steps that use the Distribution subsystem. |
Dts |
Information for job steps that use the Integration Services subsystem. |
LogReader |
Information for job steps that use the LogReader subsystem. |
Merge |
Information for job steps that use the Merge subsystem. |
PowerShell |
Information for job steps that use the PowerShell subsystem. |
QueueReader |
Information for job steps that use the QueueReader subsystem. |
Snapshot |
Information for job steps that use the Snapshot subsystem. |
TSQL |
Information for job steps that execute Transact-SQL. |