Re: Strange dbms_job problem

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 2000/06/05
Message-ID: <8hh5pm$1t1@gap.cco.caltech.edu>#1/1

Do you have job_queue_processes set to a non-zero value (but smaller than 36)?

sascha_kiefer_at_my-deja.com wrote:
: Sorry,
: my fault. I meant one day. But I tried different timestatements none of
: it worked. But in the examples they always uses sysdate+1 so I tried it
: out. But the result is always the same.

: Sacha

: > sysdate+1 means sysdate plus one day not plus one hour.
: > You have to use sysdate+1/24.
: >
: > --
: > Have a nice day
: > Michel
: >

: Sent via Deja.com http://www.deja.com/
: Before you buy.
Received on Mon Jun 05 2000 - 00:00:00 CDT