select * from all_jobs
--查询当天跑的job
select * from all_jobs where last_date>=trunc(sysdate)
--查询当天跑的job
select * from all_jobs where last_date>=trunc(sysdate)
--查询某一job执行了多少小时
select total_time/1000/60/60 from user_jobs
select * from all_jobs
--查询当天跑的job
select * from all_jobs where last_date>=trunc(sysdate)
--查询当天跑的job
select * from all_jobs where last_date>=trunc(sysdate)
--查询某一job执行了多少小时
select total_time/1000/60/60 from user_jobs