SQL Server Agent, JobSteps Object

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

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.

See Also

Manage Job Steps
Use Performance Objects
Monitor Resource Usage (System Monitor)