/SQL/How to check all scheduled jobs in oracle

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

Source: dataedo.com

Similar codes

3 votes331 views2 answers
Check data in table mysql
SQL
1 vote288 views1 answer
Python escape string for sql
SQL
0 vote326 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote309 views1 answer
How to move a column to different spot mysql
SQL
3 votes289 views1 answer
V$session not found in oracle
SQL
2 votes324 views2 answers
Convert_tz mysql
SQL
0 vote314 views1 answer
Drush run sql select
SQL
-1 vote299 views1 answer
How to create foreign key in sql server management studio
SQL
13 votes308 views6 answers
Mysql update from select
SQL
13 votes320 views2 answers
Sql join 3 tables
SQL