Monday, 6 February 2017

MSSQL - Query to list all jobs with steps


Watch this example on YouTube

select * from msdb.dbo.sysjobs as j
inner join msdb.dbo.sysjobsteps as s on
j.job_id = s.job_id

No comments:

Post a Comment