How to list all scheduler jobs and their status in Oracle

List every Scheduler job with its state, enabled flag, run counts, and last/next run time from DBA_SCHEDULER_JOBS.

SELECT owner, job_name, job_style, enabled, state,
       run_count, failure_count,
       TO_CHAR(last_start_date,'YYYY-MM-DD HH24:MI') AS last_start,
       TO_CHAR(next_run_date ,'YYYY-MM-DD HH24:MI') AS next_run
FROM   dba_scheduler_jobs
ORDER  BY owner, job_name;

-- Only your own jobs (exclude Oracle-maintained):
-- WHERE owner NOT IN ('SYS','ORACLE_OCM','DBSNMP')