/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 vote195 views1 answer
Nosql vs sql
SQL
0 vote181 views1 answer
Top frequency in sql server
SQL
5 votes211 views1 answer
Oracle nls instance
SQL
4 votes270 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
2 votes200 views2 answers
Postgresql get table names
SQL
0 vote238 views1 answer
Original Query
SQL
0 vote277 views1 answer
Having all mysql
SQL
4 votes206 views1 answer
Search column by name mysql
SQL
0 vote187 views2 answers
Sql update top 100
SQL
0 vote191 views1 answer
Sql server list table sizes
SQL