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'