Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: job is not on time
"curwen" <josephcurwen_at_despammed.com> wrote in message
news:cc68edc4.0403110833.304b8ad5_at_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, <= next_date is tomorrow at
6am
| 'trunc(sysdate+1)', <= interval is the day
after the run, at midnight
| TRUE);
|
| COMMIT;
| END;
|
|
| thanks in advance
| jc
it's doing exactly what you told it to do
;-{ mcs Received on Thu Mar 11 2004 - 11:26:32 CST