Re: dbms_job question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 23 Oct 2003 21:28:12 +0800
Message-ID: <3F97D76C.170A@yahoo.com>

Ryan Gaffuri wrote:
>
> Is it possible to have a job run every 15 minutes between 7PM and 7AM
> every day accept sundays?

dbms_job.submit(j,
  'begin
    if to_char(sysdate+5/24,''hh24'') between ''00'' and ''12''

      and to_char(sysdate,''day'') != ''sunday'' then
        my_proc;

    end if;
   end;', sysdate, 'sysdate+1/96' );

or thereabouts. You can always of course put the if-checking inside the proc itself

hth
connor Received on Thu Oct 23 2003 - 08:28:12 CDT