Re: DBMS_JOB

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 - 07:57:01 CST