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: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 4 Feb 2003 19:13:52 -0000
Message-ID: <3e402019$1_2@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 Tue Feb 04 2003 - 13:13:52 CST

Original text of this message

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