Search SQL Agent job running a specific command

  • Article

I recently had a need to find  all the Jobs running a specific stored procedure on a SQL Server instance. A simple query proved useful here.

select Job.name as JobName
from dbo.sysjobs Job, dbo.sysjobsteps Step
where
Job.job_id=Step.job_id
and
Step.command like '%sp_linkedservers%'