Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I list jobs in Oracle dbms_scheduler?

How do I list jobs created with Oracle dbms_scheduler.create(...)?

like image 353
Mark Harrison Avatar asked Dec 19 '22 16:12

Mark Harrison


1 Answers

SELECT owner, job_name, comments FROM dba_scheduler_jobs;

There are many other columns of interest as well.

like image 147
Mark Harrison Avatar answered Jan 28 '23 05:01

Mark Harrison