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 -> Job queue Question

Job queue Question

From: <amerar_at_ci.chi.il.us>
Date: Wed, 07 Jul 1999 19:31:48 GMT
Message-ID: <7m09v5$m3u$1@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 Wed Jul 07 1999 - 14:31:48 CDT

Original text of this message

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