怎么查看oracle數據庫中的job？

可以通過lasttime減去（nexttime-lasttime）*totaltime 換算成秒計算出Createtime時間例子如下： 其中49為Job名稱select last_date, to_date(to_char(last_date, 'yyyymmddHH24miss'), 'yyyymmddHH24miss') - 1 / 24 / 60 / 60 * (next_date - last_date) * 24 * 60 * 60 * total_time createdate, (next_date - last_date) * 24 * 60 * 60 * total_time startonowsecond from dba_jobs where job = '49'