/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 vote101 views1 answer
Monthly Birthday SQL Query
SQL
0 vote107 views1 answer
Sql count null values in all columns
SQL
14 votes105 views4 answers
Remove record from table sql
SQL
0 vote106 views1 answer
Oracle create table auto generated primary key
SQL
0 vote112 views1 answer
Enable sql server full text indexing
SQL
0 vote147 views1 answer
Mysql faster delete
SQL
0 vote106 views1 answer
Get primary key of table
SQL
0 vote106 views2 answers
Demmarrer un service mysql teminal cmd
SQL
1 vote117 views2 answers
Find nth highest salary of an employee
SQL
19 votes105 views6 answers
Laravel sql query
SQL