Oracle 10g | Relation between Stored Procedure and Jobs

Question

I have a problem. I have 5 stored procedure name and I would like to know which jobs are using each of this stored procedure.

I have queried the all_source in the stored procedure name but ther was not the solution. Anybody got an idea?

Thanks.

Answer 1

select job, what from user_jobs;

select job_name, job_action from USER_SCHEDULER_JOBS;