查询Oracle定时Job

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'

转载于:https://www.cnblogs.com/zzkun/archive/2013/02/21/4481794.html