/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 vote240 views1 answer
Mysql sql.gz
SQL
0 vote235 views1 answer
Get a list of tables and the primary key
SQL
0 vote226 views1 answer
Set engine to innodb
SQL
0 vote228 views1 answer
What is logical database schema
SQL
0 vote176 views1 answer
Testing sql queries
SQL
4 votes258 views3 answers
Sql find second highest salary employee
SQL
0 vote278 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote214 views1 answer
How to save data in database in mysql node
SQL
0 vote238 views1 answer
Sql examples from framework
SQL
0 vote242 views1 answer
Insert into Select * - NAYCode.com
SQL