/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 vote149 views1 answer
Allow external access to mysql
SQL
1 vote177 views1 answer
Base64 encode sql server
SQL
1 vote157 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
3 votes151 views2 answers
How to load files in mysql
SQL
3 votes182 views1 answer
RENAME table pl sql
SQL
6 votes164 views2 answers
Difference between join vs union
SQL
2 votes110 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote174 views1 answer
Sql cheetsheet
SQL
0 vote152 views1 answer
SQL add a totals of differemt rows of the same id
SQL
4 votes146 views1 answer
To date oracle with time
SQL