Search This Blog

Friday, December 29, 2023

Monitor Oracle Database Job Scheduler Activity



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 ;

No comments:

Post a Comment

Check Difference Between Two Database Objects

Step-1. Create Two DBLINK to connect with Two Database then Step-2. define logindb= DBLINKONE define remotedb= DBLINKTWO define schema_name=...