/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

16 votes327 views1 answer
Mysql smallint range
SQL
0 vote341 views1 answer
Java sql insert return id
SQL
0 vote416 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote333 views1 answer
Mysql failed to login as root@localhost
SQL
11 votes317 views3 answers
Sqlite3 create table from another table
SQL
6 votes331 views1 answer
Oracle rank
SQL
3 votes294 views1 answer
Oracle detect invalid password
SQL
16 votes322 views3 answers
Jwt secret key generator laravel
SQL
1 vote320 views3 answers
SELECT * FROM
SQL
1 vote298 views1 answer
Delete mysql from mac
SQL