/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 vote376 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote366 views1 answer
Longtext sql
SQL
0 vote376 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote286 views1 answer
<script>alert
SQL
3 votes379 views1 answer
Oracle APEX elapsed time
SQL
0 vote337 views4 answers
Mysql replace regex
SQL
0 vote355 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote388 views1 answer
Bitmap join index
SQL
0 vote353 views1 answer
Show database not empty tables postgres
SQL
0 vote352 views2 answers
Cascade syntax in sql
SQL