sql-server-agent-jobsteps-object.md

title	SQL Server Agent, JobSteps Object | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	JobSteps object SQLAgent:JobSteps
ms.assetid	44f9983c-1753-4fe0-8475-973aa2460b3a
caps.latest.revision	23
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

SQL Server Agent, JobSteps Object

The [!INCLUDEssNoVersion] Agent JobSteps performance object contains performance counters that report information about [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Agent to run, but which have not yet started running.
Total step retries	This counter reports the total number of times that [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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 [!INCLUDEssISnoversion] 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 [!INCLUDEtsql].

See Also

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