cheers, guys
jc
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<B5qdnXjct_XJPM3dRVn-hA_at_comcast.com>...
> "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 Fri Mar 12 2004 - 03:23:57 CST
