/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

1 vote365 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote350 views1 answer
Postgres get month name from date
SQL
0 vote307 views1 answer
Get only first row mysql
SQL
19 votes352 views4 answers
Rename database in sql
SQL
1 vote370 views1 answer
Replace all numbers in mysql
SQL
0 vote389 views1 answer
Mysql where sum > 0
SQL
0 vote335 views1 answer
Oracle character index
SQL
0 vote364 views1 answer
Query string starts with vowels
SQL
1 vote325 views1 answer
MySQL AND Operator
SQL
3 votes377 views2 answers
Check data in table mysql
SQL