Oracle Database - Scheduler Job

Job

Below is a set of important columns for jobs.

SELECT
  job_name,
  round(CAST(next_run_date AS DATE) - CAST (last_start_date AS DATE),2) AS diff,
  last_start_date,
  next_run_date,
  state,
  repeat_interval,
  restartable,
  all_SCHEDULER_JOBS.*
FROM
  ALL_SCHEDULER_JOBS

Metadata / Views

SELECT DISTINCT
  '(DBA|USER|ALL)_' || SUBSTR(object_name,instr(object_name,'_')+1) AS schedulerView
FROM
  all_objects
WHERE
  object_name LIKE '%SCHED%'
AND object_type = 'VIEW'
AND
  (
    object_name LIKE 'USER_%'
  OR object_name LIKE 'DBA_%'
  OR object_name LIKE 'ALL_%'
  )
ORDER BY
  schedulerView ;