DBMS_JOB - Need Help

The last couple of days I have been trying to use the DBMS_JOB package to schedule a job to run. I have tried several variations of the commands but the only way I can get a job to actually execute is by using DBMS_JOB.RUN. Everything looks like it is filled in correctly in the DBA_JOBS table but the time the job is supposed to start always comes and goes without the job running.

Is there some process in Oracle that needs to be "started" in order for things put in the DBA_JOBS table to be able run? It would seem that there must be some process that would periodically look in the table to see if there is work to do. I am wondering if that process is not running on our machine.

Below is the script I have been trying to use to schedule a job. I would expect it to cause the procedure JJC_TEST to run in 5 minutes and then every 5 minutes thereafter. What it does for me is update the DBA_JOBS table with the pertinent information and nothing else. I appreciate any help that can be given.

Declare
 job_number INTEGER;
Begin
  dbms_job.submit(job_number, 'JJC_TEST;', sysdate + 5/1440, 'sysdate + 5/1440');
  COMMIT;
END;
/

Jim Received on Wed Apr 15 1998 - 09:15:28 CDT