/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 vote165 views1 answer
Alasql delete column
SQL
0 vote184 views1 answer
Neo4j command to run script file
SQL
11 votes345 views4 answers
Round in sql
SQL
0 vote157 views3 answers
Sql all columns
SQL
0 vote185 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote199 views1 answer
Many rows to 1 string mysql
SQL
0 vote255 views1 answer
Mysql update table from select on another table
SQL
2 votes167 views1 answer
Convert series number to date in sql
SQL
1 vote231 views1 answer
Find size of all DB's postgres
SQL
2 votes163 views2 answers
Sqlalchemy filter or
SQL