CASS

set pages 1000 lines 160
col OWNER           format a12
col JOB_NAME        format a24
col JOB_ACTION      format a42
col JOB_MODE        format a20
col STATE           format a9
col START_DATE      format a15
col LAST_START_DATE format a15
col NEXT_RUN_DATE   format a15
col LOG_DATE        format a15
col Run             format 9999
col fails           format 9999 

set termout off serveroutput off heading off timing off
col title_name new_value title_name
select '['||to_char(sysdate,'HH24:MI DD-MON-RR')||' '||INSTANCE_NAME||'@'||HOST_NAME||' '||VERSION||'] ' title_name from  v$instance;
@date
ALTER SESSION SET nls_timestamp_tz_format = 'HH24:MI DDMONRR';
ALTER SESSION SET nls_timestamp_format    = 'HH24:MI DDMONRR';
set termout on serveroutput on heading on 

TTitle Left '###  Check V$DATAPUMP_JOB -  ' title_name skip 2
select LOG_ID,LOG_DATE,OWNER,JOB_NAME,OPERATION,STATUS from DBA_SCHEDULER_JOB_LOG where LOG_DATE > sysdate -7; 

TTitle Left '###  Check DBA_SCHEDULER_JOBS -  ' title_name skip 2
select OWNER,JOB_NAME,JOB_ACTION,START_DATE,STATE,RUN_COUNT Run,FAILURE_COUNT Fails,LAST_START_DATE,NEXT_RUN_DATE
from DBA_SCHEDULER_JOBS; 

TTitle Left '###  Check v$SCHEDULER_RUNNING_JOBS -  ' title_name skip 2
select * from v$SCHEDULER_RUNNING_JOBS; 

TTitle off