Re: Night Schedule using DBMS_JOB

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Wed, 23 Aug 2000 23:04:08 -0700
Message-ID: <BU2p5.11929$gb.590601@nntp2.onemain.com>

trunc(sysdate+1) will do midnight
trunc(sysdate+1)+(4/12) will do 4 am
trunc(sysdate+1)+(43/48) will do 9:30 PM

...
<salman_z_g_at_my-deja.com> wrote in message news:8o1k8p$n38$1_at_nnrp1.deja.com...
> How can I schedule a job to run only during night (say between 8pm-5am)
> using Oracle Job Scheduler?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 24 2000 - 01:04:08 CDT