/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 vote160 views2 answers
Nested query
SQL
0 vote132 views1 answer
Sql with example
SQL
0 vote149 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote140 views1 answer
Tsql get beginning of year
SQL
1 vote150 views1 answer
Create table variable in sql stored procedure
SQL
8 votes163 views1 answer
Insert a select statement into a table
SQL
51 votes238 views6 answers
Opera gx
SQL
0 vote189 views1 answer
Sql server system messeges
SQL
0 vote155 views1 answer
"Hello User Name"
SQL
1 vote133 views1 answer
Oracle stop job
SQL