/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 vote110 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote121 views1 answer
Sql server union if table exist
SQL
-1 vote114 views1 answer
Sql set max value in column
SQL
0 vote109 views1 answer
Search db for table name
SQL
8 votes137 views1 answer
Mysql dump restore
SQL
3 votes102 views1 answer
Mysql insert on dupèlicate
SQL
4 votes106 views3 answers
Postgres set default value
SQL
0 vote102 views1 answer
Mysql record group by created date count
SQL
0 vote113 views1 answer
Oracle session statistics
SQL
-1 vote104 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL