/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 vote145 views1 answer
Clear query cache sql server
SQL
2 votes174 views1 answer
Sql percentage with % rounded down
SQL
0 vote167 views1 answer
Sql min
SQL
0 vote188 views1 answer
Mysql grant user wildcard database
SQL
0 vote151 views1 answer
Set column in all row mysql
SQL
0 vote185 views1 answer
Sqlcl format
SQL
0 vote166 views1 answer
How to check common records in 2 table
SQL
0 vote148 views1 answer
Run mssql server terminal
SQL
1 vote187 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote162 views1 answer
Providername system.data. mysql
SQL