| title | SQL Server Agent, JobSteps Object | Microsoft Docs | ||
|---|---|---|---|
| description | Learn about the SQL Server Agent JobSteps performance object, which contains performance counters that report information about SQL Server Agent job steps. | ||
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | performance | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 44f9983c-1753-4fe0-8475-973aa2460b3a | ||
| author | WilliamDAssafMSFT | ||
| ms.author | wiassaf |
[!INCLUDE SQL Server] 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]. |
Manage Job Steps
Use Performance Objects
Monitor Resource Usage (System Monitor)