/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 vote187 views2 answers
Influxdb delete measurement based on date
SQL
0 vote255 views1 answer
Select year from dual oracle
SQL
5 votes222 views4 answers
Mysql on duplicate key update
SQL
0 vote229 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote212 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
2 votes219 views1 answer
Oracle kill job by sid
SQL
7 votes216 views6 answers
Group_concat mysql
SQL
1 vote283 views1 answer
Postgresql can you have null foreign key
SQL
2 votes221 views2 answers
How to DROP a table in mysql
SQL
4 votes215 views1 answer
Postgresql change default value
SQL