查看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;