Re: Job queue Question

From: B. Cipelletti <bruno.cipelletti_at_gemplus.com>
Date: Thu, 8 Jul 1999 11:29:50 -0400
Message-ID: <7m2g6c$ss3$1@gromit.dvlmp.gemenos.south-europe.gemplus>

Make sure parameter JOB_QUEUE_PROCESSES in init.ora is set to value other than 0. It determines the number of background processes that are started to take care of job queue processing.

Bruno Cipelletti
Gemplus Canada inc.

<amerar_at_ci.chi.il.us> wrote in message news:7m09v5$m3u$1_at_nnrp1.deja.com...
>
>
>
> Hello,
>
> I put a job into the job queue with this command:
>
> VARIABLE jobno number;
> begin
> DBMS_JOB.SUBMIT(:jobno,
> 'cash_man.water_pull;',
> sysdate,
> 'sysdate + 18/24');
> commit;
> end;
> /
>
> I want the job to run everyday at 6:00pm.......this is not happening.
> Can someone help me out with the interval??
>
> Please cc a copy to email....
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 08 1999 - 10:29:50 CDT