/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

12 votes192 views1 answer
Docker run mysql image
SQL
0 vote198 views1 answer
Amount of entries in a table psql
SQL
0 vote216 views1 answer
Postgres copy command
SQL
1 vote187 views1 answer
Expression number 1 of select list is not in group by clause
SQL
2 votes187 views1 answer
Q operator in plsql
SQL
0 vote209 views2 answers
Plpgsql
SQL
0 vote192 views1 answer
Show table details postgresql
SQL
0 vote220 views1 answer
Sqlalchemy empty table
SQL
3 votes213 views1 answer
Oracle cannot access v$session
SQL
0 vote186 views1 answer
Execute sql stored procedure in powershell
SQL