查询系统中运行的JOB

 

SELECT JOB,
WHAT,
TO_CHAR(NEXT_DATE, 'yyyy/mm/dd hh24:mi:ss'),
BROKEN,
FAILURES,
SCHEMA_USER,
LOG_USER,
PRIV_USER
FROM DBA_JOBS;