Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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%'