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'