The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

  DateTime Here

Job listing with steps and tsql

SQL Agent job listing, jobs, steps and tsql / commands executed.

Not really useful, but helpful when someone wants to see all the jobs and the steps they are executing.

Save as an excel file, or publish to rdl and push to a reporting site so they can always see it themselves....

select sj.name,sj.description,sjs.step_name,
 sjs.subsystem,sjs.command,sjs.database_name,
 sjs.output_file_name
 from sysjobs sj
 inner join sysjobsteps sjs on sj.job_id = sjs.job_id
-- where sj.name like 'cy%'
 order by sj.job_id,sjs.step_id

 


Blog Home