pchriste24
10/29/2018 - 6:24 PM

Search inside of SQL job Definitions

Search inside of SQL job Definitions

SELECT SERVERPROPERTY('SERVERNAME') as [InstanceName],
	j.job_id,
	j.name,
	js.step_id,
	js.command,
	j.enabled 
FROM	msdb.dbo.sysjobs j
JOIN	msdb.dbo.sysjobsteps js
	ON	js.job_id = j.job_id 
WHERE	js.command LIKE '%tdman%' -- replace keyword with the word or stored proc that you are searching for
GO