Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Night Schedule using DBMS_JOB

Re: Night Schedule using DBMS_JOB

From: <salman_z_g_at_hotmail.com>
Date: Thu, 24 Aug 2000 20:18:26 GMT
Message-ID: <8o3vtq$elf$1@nnrp1.deja.com>

Thanks.

Still how can I run between 8-5 everyhour and everyday.

In article <BU2p5.11929$gb.590601_at_nntp2.onemain.com>,   "Barbara Kennedy" <barbken_at_teleport.com> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 15:18:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US