Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft