Application scheduler jobs and next run

1CLEAR COLUMNS2SET LINESIZE 160 PAGESIZE 200 TRIMOUT ON TAB OFF3COLUMN owner         FORMAT A154COLUMN job_name      HEADING "JOB"      FORMAT A355COLUMN enabled       FORMAT A76COLUMN state         FORMAT A107COLUMN last_run      HEADING "LAST RUN" FORMAT A168COLUMN next_run      HEADING "NEXT RUN" FORMAT A169COLUMN failure_count HEADING "FAILURES" FORMAT 99,99010 11SELECT owner, job_name, enabled, state,12       TO_CHAR(last_start_date, 'YYYY-MM-DD HH24:MI') AS last_run,13       TO_CHAR(next_run_date, 'YYYY-MM-DD HH24:MI') AS next_run,14       failure_count15FROM dba_scheduler_jobs16WHERE owner NOT IN (SELECT username FROM dba_users WHERE oracle_maintained = 'Y')17ORDER BY next_run_date NULLS LAST;