SELECT /* 查看JOB执行状态*/
T.OWNER,
T.JOB_NAME,
T.STATUS,
TO_CHAR(T.ACTUAL_START_DATE, 'YYYY-MM-DD HH24:MI:SS') AS ACTUAL_START_DATE,
TO_CHAR(
ACTUAL_START_DATE + NUMTODSINTERVAL(SUBSTR(RUN_DURATION,6,2),'HOUR') +
NUMTODSINTERVAL(SUBSTR(RUN_DURATION,9,2),'MINUTE')+
NUMTODSINTERVAL(SUBSTR(RUN_DURATION,12,2),'SECOND')
,'YYYY-MM-DD HH24:MI:SS') AS ACTUAL_END_DATE,
T.ADDITIONAL_INFO,
T.ERROR# AS ERROR
FROM USER_SCHEDULER_JOB_RUN_DETAILS T
ORDER BY LOG_DATE DESC;