Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Comments

Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...