/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 vote281 views1 answer
Key validation sql
SQL
0 vote270 views1 answer
Mssql + bit + in python orm
SQL
1 vote270 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote282 views1 answer
Mysql server not starting in xampp in mac
SQL
2 votes279 views1 answer
Sql update \
SQL
1 vote259 views1 answer
How to drop function in sql
SQL
7 votes261 views1 answer
Oracle reset sequence
SQL
5 votes267 views1 answer
Sqlite alter table add column
SQL
0 vote273 views3 answers
Remove folders from remote git
SQL
0 vote256 views1 answer
Sql describe
SQL