/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

5 votes128 views1 answer
Oracle columns in all_tables
SQL
0 vote121 views1 answer
Postgres in operator with comma separated values
SQL
4 votes135 views2 answers
Mysql alter table set column unique
SQL
0 vote124 views1 answer
Mssql disable foreign key constraint
SQL
0 vote111 views1 answer
Restart sql server command line linux
SQL
8 votes118 views3 answers
Connect python to mysql
SQL
0 vote131 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote115 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
7 votes118 views2 answers
Mysql get year from date
SQL
0 vote188 views1 answer
Database timezone
SQL