/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 vote281 views1 answer
Mysql jdbc timezone
SQL
0 vote304 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote281 views1 answer
Sql remove last 2 digit
SQL
6 votes286 views2 answers
Where clause in sql
SQL
0 vote287 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
17 votes298 views4 answers
Sort by mysql
SQL
0 vote302 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote288 views1 answer
Sql server beginning of month
SQL
2 votes276 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote289 views1 answer
Drush sql-dump
SQL