/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 vote332 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote401 views2 answers
Check if sql temp table exists
SQL
0 vote357 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
3 votes344 views3 answers
List columns in table postgres
SQL
0 vote356 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote353 views1 answer
Count in sql and diff
SQL
0 vote344 views1 answer
Formatting code with SQL Developer
SQL
11 votes330 views4 answers
Round in sql
SQL
-1 vote323 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote347 views1 answer
Name '_mysql' is not defined
SQL