SQL Server Agent, JobSteps object

Applies to: SQL Server

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.

Related content

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