job is not on time

From: curwen <josephcurwen_at_despammed.com>
Date: 11 Mar 2004 08:33:58 -0800
Message-ID: <cc68edc4.0403110833.304b8ad5@posting.google.com>

#oracle 9i enterprise on red-hat

Hi all
I can't get an oracle job to repeat at the desired time every day

it should start at 6am every day
it works the very first time, but the day after just start at midnight

the job is created with the following script:

variable jobno number;
variable instno number;
BEGIN
dbms_job.submit(
   :jobno,
'scott.engine_pck.my_proc;',

   trunc(sysdate+1)+6/24,
'trunc(sysdate+1)',

   TRUE);    COMMIT;
END; thanks in advance
jc Received on Thu Mar 11 2004 - 10:33:58 CST