查看oracle job的运行日志

查看计划任务的日志

select * from user_scheduler_job_log

select * from user_scheduler_job_run_details

查看正在运行的job

select sid,job from dba_jobs_running; 

查看所有的job

select ju.name username, j.obj#, jo.name, j.failure_count from
sys.obj$ jo, sys.user$ ju, sys.obj$ co, sys.scheduler$_job j
where j.obj# = jo.obj# AND jo.owner# = ju.user# AND j.class_oid = co.obj#(+) order by name;