Scheduler JOBS

--------------------------------------------------------------
-- Failed scheduler jobs of application for recent 24 hours --
--------------------------------------------------------------
CLEAR COLUMNS
COLUMN OWNER FORMAT A10
COLUMN JOB_NAME FORMAT A30
COLUMN STATUS FORMAT A10
COLUMN ADDITIONAL_INFO FORMAT A47
DEFINE LINE2='                          CRITICAL!!! Failed scheduler jobs of application for recent 24 hours                          '
TTITLE CENTER LINE1 SKIP 1 CENTER LINE2 SKIP 1 CENTER LINE1

SELECT OWNER, 
JOB_NAME, 
TO_CHAR(LOG_DATE,'DD/MM/YYYY HH24:MI:SS') LOG_DATE, 
STATUS, 
ADDITIONAL_INFO 
FROM DBA_SCHEDULER_JOB_LOG
WHERE LOG_DATE > SYSDATE - 1 
AND STATUS <> 'SUCCEEDED' 
AND OWNER = &DB_SCHEMA
ORDER BY OWNER, LOG_DATE;

-----------------------------------------------------------
-- Currently running schedular jobs of application users --
-----------------------------------------------------------
CLEAR COLUMNS
COLUMN REPEAT_INTERVAL FORMAT A43
COLUMN OWNER FORMAT A10
COLUMN STATE FORMAT A8
DEFINE LINE2='                             INFO!!! Currently running schedular jobs of application users                              '
TTITLE CENTER LINE1 SKIP 1 CENTER LINE2 SKIP 1 CENTER LINE1

SELECT OWNER, JOB_NAME, REPEAT_INTERVAL, ENABLED, STATE, TO_CHAR(LAST_START_DATE,'DD/MM/YYYY HH24:MI:SS') LAST_START_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER = &DB_SCHEMA
AND STATE = 'RUNNING'
ORDER BY OWNER, LAST_START_DATE;