select * from dba_jobs; //执行完的调度任务

select * from dba_jobs_running; //正在执行的调度任务

select * from user_jobs;//调度任务

select * from user_source where type = 'procedure';

select * from user_objects where object_type = 'procedure';

select text from user_source where type = 'procedure' and name = 'procedure_name'