/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

0 vote191 views2 answers
Jsonb
SQL
0 vote218 views1 answer
Sql date with year
SQL
0 vote201 views1 answer
Datatables server side filter where clause
SQL
12 votes200 views5 answers
Rename table in mysql
SQL
3 votes178 views1 answer
Oracle nextval
SQL
3 votes221 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
11 votes188 views1 answer
Sql query to find duplicates in column
SQL
1 vote210 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote226 views1 answer
Mysql case when on date
SQL
3 votes206 views2 answers
Order by postgresql
SQL