set lines 200 set pages 3000 SET FEEDBACK OFF SET DEFINE On column owner format a15 column SERVICE format a50 column state format a9 column repeat_interval format a20 column LAST_START_DATE format a17 column DURATION_MIN format 9999 column NEXT_RUN_DATE format a17 column run format 9999 column fail format 9999 column JOB_CLASS_NAME format a30 SELECT JOB_CLASS_NAME, SERVICE, LOGGING_LEVEL, LOG_HISTORY, LOG_HISTORY LOG_HISTORY_DAYS FROM DBA_SCHEDULER_JOB_CLASSES;