怎么查看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'