Blog Post

SQL Server Agent Job Steps

,

To list a SQL Server Agent Job Steps use the T-SQL example below.

This example displays the step id, SQL Server Agent Job name, Step name.

The code has 1 input parameter - @job_name

 

DECLARE @job_name VARCHAR(128)
SET @job_name = 'My SQL Server Agent Job'
SELECT js.step_id ,j.name,js.step_name FROM sysjobsteps js inner join sysjobs j 
ON js.job_id=j.job_id 
WHERE j.name = @job_name ORDER BY step_id

 

See Also

SQL Server agent fixed roles

SQL Agent Jobs – Schedule in seconds

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating