/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

1 vote171 views1 answer
Increase existing date in sql oracle
SQL
4 votes148 views2 answers
Sql server date now
SQL
0 vote173 views1 answer
Where field is null sql knex
SQL
1 vote157 views1 answer
Oracle nvl2
SQL
2 votes213 views1 answer
How to select from mssql
SQL
-1 vote185 views1 answer
Sql show custom constraints
SQL
0 vote175 views1 answer
Mysql c commands
SQL
1 vote164 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
1 vote156 views1 answer
Sql try catch
SQL
0 vote140 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL