Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Night Schedule using DBMS_JOB
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
![]() |
![]() |