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
|