Following query can be used to search through all the job steps for any Keyword.
USE [msdb]
GO
SELECT j.job_id,
j.name,
js.step_id,
js.command,
j.enabled
FROM dbo.sysjobs j
JOIN dbo.sysjobsteps js
ON js.job_id = j.job_id
WHERE js.command LIKE '%Keyword_Search%'
GO
Comments
Post a Comment