/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 vote243 views1 answer
Sql query for select from specific columns in a table
SQL
2 votes259 views3 answers
How to pass password mysql command line
SQL
5 votes298 views2 answers
Functions
SQL
3 votes279 views2 answers
How to force truncate a table in mysql
SQL
0 vote261 views1 answer
Sql server isnull function nor working count
SQL
0 vote255 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote261 views1 answer
What is top n result in sql
SQL
0 vote325 views1 answer
Php insert null mysql
SQL
0 vote288 views1 answer
How to move a columns location in mysql
SQL
3 votes259 views3 answers
Mysql order by list
SQL