Searching for a specific JOB by the procedure it calls

Question

Is it possible to search a JOB by the code it executes? I.E. I want to find the JOB that launches a certain stored procedure.

Is there a query to do it?

Answer 1

Try using the all_dependencies view.

select * from all_dependencies where referenced_name = 'YOUR_STORED_PROC';