/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
Tsql cmd exec script from file
SQL
8 votes383 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote273 views1 answer
Contact mysql column field
SQL
1 vote285 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote281 views1 answer
To Create directory
SQL
0 vote272 views1 answer
Mysql dump everythign
SQL
0 vote255 views1 answer
Django mysqlclient connection string
SQL
0 vote270 views1 answer
Pgadmin see indexes
SQL
0 vote238 views1 answer
Check sql query executed wp
SQL
13 votes255 views5 answers
Oracle list tables
SQL