Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB

Re: DBMS_JOB

From: Dirk Tschentscher <dirkTHIS_at_REMvolkswagen.de>
Date: Thu, 6 Feb 2003 16:31:39 +0100
Message-ID: <b1tvb3$4ms5@doiweb4.volkswagen.de>


Hello Connor,
yes, the parameters are
job_queue_interval = 60 and
job_queue_processes = 10.

Please look at the first-mail in the thread "SNPx processes", there are more infos.

Rgds

    Dirk

"Connor McDonald" <connor_mcdonald_at_yahoo.com> schrieb im Newsbeitrag news:3E4269AD.6544_at_yahoo.com...
> Dirk Tschentscher wrote:
> >
> > Hi Paul,
> >
> > Yes I did commit.
> > Please look at the thread "dbms_job problem"
> > There I described more details...
> >
> > Thanks
> > Dirk
> >
> > "Paul Brewer" <paul_at_paul.brewers.org.uk> schrieb im Newsbeitrag
> > news:3e402019$1_2_at_mk-nntp-1.news.uk.worldonline.com...
> > > "Dirk Tschentscher" <dirkTHIS_at_REMvolkswagen.de> wrote in message
> > > news:b1o0le$9tt7_at_doiweb4.volkswagen.de...
> > > > Hello !
> > > > We've got two databases
> > > > Test 8.1.6.0.0 (where I have dba access) with Windows NT 40
SP6
> > > > prod 8.1.7.2.0 (where I don't have dba access) some kind of
Unix
> > (I
> > > > don't know...)
> > > > with the identical parameters
> > > > job_queue_interval = 60 and
> > > > job_queue_processes = 10.
> > > >
> > > > I submit my job with the following procedure :
> > > >
> > > > Procedure zz_job_start is
> > > > jobno number;
> > > > BEGIN
> > > > dbms_job.submit(jobno,'STAMM_AUFTRAEGE_ABARBEITEN;',
> > > > sysdate,'sysdate + (1/(30*24))'); -- alle 2
Minuten
> > > > EXCEPTION WHEN others THEN
> > > > dbms_output.put_line(sqlerrm);
> > > > END;
> > > >
> > > > In the test environment, everything works fine,
> > > > but in prod nothing happens...
> > > >
> > > > I can start the job with dbms_job.run, then the job works correct,
> > > > but it doesn't run the next time...
> > > >
> > > > Has anyone a hint what I can do ?
> > > >
> > > > Rgds
> > > > Dirk
> > > >
> > > >
> > > >
> > > >
> > > Did you commit?
> > >
> > > Regards,
> > > Paul
> > >
> > >

>

> You have got job_queue_processes > 0 ?
>

> hth
> connor
Received on Thu Feb 06 2003 - 09:31:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US