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?

enter image description here

there is a system view for the dbms_jobs. I currently don't know its name, but you should be able to find it pretty quick. — ZeissS, Sep 22 '11 at 10:54

score 2 · Answer 1 · answered Sep 22 '11 at 11:22

2

select 
  * 
from 
  user_jobs 
where 
  what like '%my_token%';

answered Sep 22 '11 at 11:22

Florin Ghita

score 1 · Accepted Answer · answered Sep 22 '11 at 13:31

1

Try using the all_dependencies view.

select * from all_dependencies where referenced_name = 'YOUR_STORED_PROC';

answered Sep 22 '11 at 13:31

furman87

2 Answers2