Re: DBMS_JOB

From: Dirk Tschentscher <dirkTHIS_at_REMvolkswagen.de>
Date: Wed, 5 Feb 2003 14:02:52 +0100
Message-ID: <b1r224$8k09@doiweb4.volkswagen.de>

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

>
> Received on Wed Feb 05 2003 - 07:02:52 CST