SQL Server Find What Jobs Are Running a Procedure

Question

Is there a way to find out what jobs are using a certain stored procedure?

Answer 1

This will capture instances where the procedure is explicitly referenced in the job step:

SELECT j.name    FROM msdb.dbo.sysjobs AS j   WHERE EXISTS    (     SELECT 1 FROM msdb.dbo.sysjobsteps AS s       WHERE s.job_id = j.job_id       AND s.command LIKE '%procedurename%'   ); 

If it is called by something else that is called from the job, or the command is constructed with dynamic SQL, this might be a little more difficult to track down. Note also that if your procedure name can also appear naturally in other code, comments, etc. that it may produce false positives.