Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Job queue Question
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');
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