Re: Night Schedule using DBMS_JOB

salman_z_g_at_hotmail.com wrote:
>
> 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.

Change the job to check

procedure blah is
begin
  if <check the hours range> is ok then

     what your proc would normally do
  else

     do nothing
  end if;
end;

and then schedule 'blah' every hour (or whatever you like)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse