TODO:
Have you ever wanted to find text in a SQL Agent Job or Job Step?
SOLUTION:
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 '%Enter Text Here%'
NOTES:
There are no notes on this topic.
TODO:
Have you ever wanted to find text that exists in a stored procedure, function or trigger using T-SQL?
SOLUTION:
SELECT DISTINCT *
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%enter your search criteria here%'
ORDER BY 2,1
NOTES:
There are no notes on this topic.