How do I list jobs in Oracle dbms_scheduler?

oracle dbms-scheduler
Mark Harrison picture Mark Harrison · Jun 8, 2016 · Viewed 18.7k times · Source

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

Answer

Mark Harrison picture Mark Harrison · Jun 8, 2016 
SELECT owner, job_name, comments FROM dba_scheduler_jobs;

There are many other columns of interest as well.

Related questions

DBMS_SCHEDULER.DROP_JOB only if exists

I have a sql script that I must run after I import a dump. among other things the script does, it does the following: BEGIN --remove program SYS.DBMS_SCHEDULER.DROP_PROGRAM(program_name=>'STATISTICS_COLUMNS_PROG',FORCE=>…

Read More
dbms_scheduler.run_job('jobName) fails to run

I'm trying to run a scheduled job manually, the job looksa like this DBMS_SCHEDULER.CREATE_JOB ( job_name => 'UPDATE_PLAYER_STATES', job_type => 'STORED_PROCEDURE', job_action => 'PLAYER_STATE_UPDATER', repeat_interval => 'FREQ=DAILY;BYHOUR=0…

Read More
How to execute a procedure with DBMS_SCHEDULER.CREATE_JOB procedure

I want to create a job that would drop a database object at a given date. The job created all right but the procedure is not executed. Tried executing the procedure alone and it works. Here's the code for the …

Read More