SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS ;
SELECT * FROM DBA_SCHEDULER_JOBS WHERE LAST_START_DATE > SYSDATE - 1 ORDER BY CAST(LAST_START_DATE AS DATE) ;
SELECT * FROM DBA_SCHEDULER_JOB_LOG WHERE LOG_DATE > SYSDATE - 1 ORDER BY LOG_DATE ;
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE ACTUAL_START_DATE > SYSDATE - 1 order by ACTUAL_START_DATE ;
SELECT * FROM DBA_SCHEDULER_JOB_LOG WHERE LOG_DATE > SYSDATE - 1 ORDER BY LOG_DATE ;
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE ACTUAL_START_DATE > SYSDATE - 1 order by ACTUAL_START_DATE ;
No comments:
Post a Comment