ORACLE.查看定时作业清单

SELECT JOB_NAME, ENABLED, STATE, LAST_START_DATE, NEXT_RUN_DATE, REPEAT_INTERVAL

FROM DBA_SCHEDULER_JOBS

WHERE OWNER = 'NJ_OPERATION_USER'

;

 

SELECT JOB, NEXT_DATE, INTERVAL, WHAT

FROM USER_JOBS;

 

SELECT * FROM USER_JOBS;