/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 vote279 views3 answers
How to find all role in mysql
SQL
1 vote241 views1 answer
Sql avg group by
SQL
0 vote233 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote233 views1 answer
Sub query in linq
SQL
0 vote190 views1 answer
Hangfire clean script
SQL
4 votes237 views3 answers
Copy table postgres
SQL
3 votes233 views3 answers
How to add month in update sql
SQL
-1 vote238 views1 answer
Add bool column in sql
SQL
3 votes254 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
7 votes241 views2 answers
Execute mysql file
SQL