/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 vote225 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote203 views1 answer
Ms sql database data size
SQL
1 vote203 views1 answer
Sql eliminare un record
SQL
0 vote212 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
1 vote203 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote207 views1 answer
Mysql isshow
SQL
0 vote201 views1 answer
Change data type in mysql
SQL
0 vote229 views1 answer
Yesql
SQL
0 vote214 views1 answer
How to find sql server installation folder
SQL
0 vote214 views1 answer
Mysql in clausule string array
SQL