Re: jobs are not executed at the proper time

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 9 Nov 1999 13:07:09 -0800
Message-ID: <80a2fo$mv8$1@plo.sierra.com>

what is the value of the JOB_QUEUE_PROCESSES parameter?

are there <many> other jobs running?

as a user, select job, next_date, substr(what,1,50) what from user_jobs; or,
as system, select ..... from all_jobs;

Akram JARO <e9225501_at_fbma.tuwien.ac.at> wrote in message news:8093oq$kdu$1_at_news.tuwien.ac.at...
> I submitted a job which should be executed immediate and repeated every 5
> minutes
>
> (DBMS_JOB.SUBMIT(:v_jobnum,'pp;',sysdate,'sysdate+(5/(24*60))');
>
> But the job is executed for the first time only after a couple of hours.
>
> It is possible to force the immediate execution with RUN and then it is
> re-executed every 5 minutes as
> it should be, but this solution is not good for me.
>
> I think the values of the initseed-file are correct:
>
> job_queue_interval = 10
> job_queue_keep_connections = false
>
> Please tell what the problem may be.
>
> --
> thanx in advance
>
>
>

---

**
> MfG
> Akram JARO
> email e9225501_at_fbma.tuwien.ac.at
>
> Student at the Vienna University of Technology
>
>
>

---

**
>
>
>
>
>
>
Received on Tue Nov 09 1999 - 15:07:09 CST