Answers for "oracle view scheduled jobs on table"

how to check all scheduled jobs in oracle

select owner as schema_name,
       job_name,
       job_style,
       case when job_type is null 
                 then 'PROGRAM'
            else job_type end as job_type,  
       case when job_type is null
                 then program_name
                 else job_action end as job_action,
       start_date,
       case when repeat_interval is null
            then schedule_name
            else repeat_interval end as schedule,
       last_start_date,
       next_run_date,
       state
from sys.all_scheduler_jobs
order by owner,
         job_name;
Code has been copied

oracle list scheduled jobs

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER NOT IN ('SYS')
ORDER BY ENABLED, OWNER, JOB_NAME;

-- Running jobs:
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
	ELAPSED_TIME, CPU_USED 
FROM DBA_SCHEDULER_RUNNING_JOBS
ORDER BY OWNER, JOB_NAME;