how to check all scheduled jobs in oracle

Solutions on MaxInterview for how to check all scheduled jobs in oracle by the best coders in the world

showing results for - "how to check all scheduled jobs in oracle"
Roberta
08 May 2019
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