Printed 2015/11/26 11:36AM

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 ,,js.step_name FROM sysjobsteps js inner join sysjobs j 
ON js.job_id=j.job_id 
WHERE = @job_name ORDER BY step_id


See Also

SQL Server agent fixed roles

SQL Agent Jobs – Schedule in seconds

Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.