Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_JOB - Need Help
Yes, you need to set JOB_QUEUE_PROCESSES/SNAPSHOT_REFRESH_PROCESSES in
your INIT.ORA. It defaults to none, so there are no Oracle processes to
run your jobs.
Jim Curry wrote:
>
> 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 - 16:59:15 CDT