/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 vote123 views1 answer
Remove from table where
SQL
1 vote138 views1 answer
Sql first day quarter
SQL
1 vote131 views1 answer
Mariadb get column names from table
SQL
0 vote127 views1 answer
Sql create text column limited values
SQL
0 vote129 views1 answer
Mysql docker image for macbook m1
SQL
0 vote121 views2 answers
Clear window pl sql
SQL
0 vote127 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote163 views1 answer
Bash block size ls /var/lib/mysql
SQL
3 votes138 views1 answer
Oracle user privileges
SQL
0 vote142 views1 answer
How to move a column to different spot mysql
SQL