Wednesday, June 26, 2013

Find a job with a particular text in SQL Server

Find a job in SQL Server with a particular text.


USE [msdb]
GO
SELECT     j.job_id,
     s.srvname,
     j.name,
     js.step_id,
     js.command,
     j.enabled
FROM dbo.sysjobs j
JOIN dbo.sysjobsteps js
     ON   js.job_id = j.job_id
JOIN master.dbo.sysservers s
     ON   s.srvid = j.originating_server_id

WHERE js.command LIKE N'%text to search in job%'


No comments:

Post a Comment