/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

1 vote317 views3 answers
Psql fatal database does not exist
SQL
2 votes362 views2 answers
Postgresql get table names
SQL
0 vote334 views1 answer
Date on SQL
SQL
3 votes313 views2 answers
How to View column names of a table in SQL
SQL
0 vote316 views1 answer
Mysql workbench not showing schemas
SQL
12 votes341 views4 answers
Psql command not found
SQL
0 vote328 views1 answer
How to select only id where is not in column mysql
SQL
0 vote342 views1 answer
Geopoint from json mysql function
SQL
0 vote343 views1 answer
Mssql dockere
SQL
-1 vote351 views2 answers
Postgres autoincrement primary key
SQL