/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 vote265 views1 answer
Postgres get running query
SQL
0 vote319 views1 answer
Postgresql like
SQL
2 votes302 views2 answers
Postgresql search all tables for column name
SQL
0 vote292 views1 answer
Add column in sql server ubuntu
SQL
0 vote276 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
14 votes300 views2 answers
Oracle export trigger ddl
SQL
0 vote278 views1 answer
Raiserror nowait sql server
SQL
0 vote280 views1 answer
Mysql select where text contains
SQL
0 vote297 views1 answer
Install squirrel sql ubuntu
SQL
0 vote297 views1 answer
Table or view does not exist
SQL