/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 vote147 views1 answer
Python mysql query to dataframe
SQL
5 votes154 views1 answer
Get column name sql server
SQL
0 vote141 views1 answer
List all permissions on a table in postgres
SQL
0 vote156 views1 answer
Mysql regex select
SQL
1 vote145 views1 answer
Mariadb case switch
SQL
1 vote169 views1 answer
Oracle repeat_interval 5 minutes
SQL
13 votes178 views3 answers
Sql select from multiple tables without join
SQL
3 votes139 views1 answer
DB: in eloquent using sql
SQL
-1 vote145 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote169 views1 answer
Sqlite3 pragma foreign keys
SQL