SQL Sizzlers
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment