Thursday, January 28, 2016

Script to find a keyword in the SQL agent jobs

select sj.name as jobname
 , sjs.step_name as jobstep
 , sjs.command as command
from msdb..sysjobs sj
inner join msdb..sysjobsteps sjs
 on sj.job_id = sjs.job_id
where sj.enabled = 1
and command like '%KEYWORD%'
order by sj.name, sjs.step_id

No comments:

Post a Comment