1select owner as schema_name,
2 job_name,
3 job_style,
4 case when job_type is null
5 then 'PROGRAM'
6 else job_type end as job_type,
7 case when job_type is null
8 then program_name
9 else job_action end as job_action,
10 start_date,
11 case when repeat_interval is null
12 then schedule_name
13 else repeat_interval end as schedule,
14 last_start_date,
15 next_run_date,
16 state
17from sys.all_scheduler_jobs
18order by owner,
19 job_name;
20Code has been copied
1SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
2FROM DBA_SCHEDULER_JOBS
3WHERE OWNER NOT IN ('SYS')
4ORDER BY ENABLED, OWNER, JOB_NAME;
5
6-- Running jobs:
7SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID,
8 ELAPSED_TIME, CPU_USED
9FROM DBA_SCHEDULER_RUNNING_JOBS
10ORDER BY OWNER, JOB_NAME;