Scheduled Jobs

List scheduler jobs with their owner, state and enabled status.

SELECT
    owner,
    job_name,
    job_type,
    enabled,
    state
FROM dba_scheduler_jobs
ORDER BY owner, job_name;

Identify scheduler jobs currently executing.

SELECT
    owner,
    job_name,
    session_id,
    running_instance,
    elapsed_time
FROM dba_scheduler_running_jobs
ORDER BY owner, job_name;

Review recent scheduler executions and their recorded status.

SELECT
    owner,
    job_name,
    status,
    actual_start_date,
    run_duration
FROM dba_scheduler_job_run_details
ORDER BY actual_start_date DESC
FETCH FIRST 30 ROWS ONLY;

Identify recent scheduler runs that did not complete successfully.

SELECT
    owner,
    job_name,
    status,
    error#,
    actual_start_date
FROM dba_scheduler_job_run_details
WHERE status <> 'SUCCEEDED'
ORDER BY actual_start_date DESC;

Find scheduler jobs marked broken or disabled for investigation.

SELECT
    owner,
    job_name,
    enabled,
    state,
    failure_count,
    last_start_date
FROM dba_scheduler_jobs
WHERE state = 'BROKEN'
   OR enabled = 'FALSE'
ORDER BY owner, job_name;

Review jobs and their next planned execution times.

SELECT
    owner,
    job_name,
    enabled,
    state,
    next_run_date
FROM dba_scheduler_jobs
WHERE enabled = 'TRUE'
ORDER BY next_run_date;