msdb
select JobName = job.name ,s.database_name ,s.command ,job.job_id ,s.step_id ,s.step_name ,s.subsystem from msdb.dbo.sysjobs job left join msdb.dbo.sysjobsteps s on job.job_id = s.job_id where 1=1 and job.name like 'My System%' order by job.name ,s.step_id
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.