| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
SQL Server Agent, JobSteps object |
Learn about the SQL Server Agent JobSteps performance object, which contains performance counters that report information about SQL Server Agent job steps. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!INCLUDE SQL Server]
The [!INCLUDE ssNoVersion] Agent JobSteps performance object contains performance counters that report information about [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] Agent to run, but which have not yet started running. |
| Total step retries | This counter reports the total number of times that [!INCLUDE msCoName] [!INCLUDE ssNoVersion] 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 [!INCLUDE ssISnoversion] 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 [!INCLUDE tsql]. |