/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 vote206 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote205 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote191 views1 answer
Copy postgres table from one schema into another
SQL
5 votes254 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote192 views1 answer
Execut sql python
SQL
4 votes245 views6 answers
Second max salary in sql
SQL
0 vote211 views1 answer
Mysql check if lowercase
SQL
0 vote211 views1 answer
Oracle right characters
SQL
0 vote239 views1 answer
Replace \n sql
SQL
0 vote252 views1 answer
Mariadb.service failed with result 'exit-code'
SQL