Re: dbms_job on workdays
From: Joost Bataille <j.r.l.m.batailleDELETE_THIS_at_uva.nl>
Date: Mon, 8 Oct 2001 20:04:51 +0200
Message-ID: <9psps9$7gn$1_at_news.surfnet.nl>
Date: Mon, 8 Oct 2001 20:04:51 +0200
Message-ID: <9psps9$7gn$1_at_news.surfnet.nl>
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3BC1E38B.69D1_at_yahoo.com...
>>does any of you how to instruct dbms_job to only run on workdays
> >Should be something in the interval parameter...
>
> dbms_job.submit(jobno,
> 'begin
> if to_char(sysdate,''DY'') not in (''SAT'',''SUN'') then
> my_proc;
> end if;
> end;',rest_of_parms);
>
> --
> ==============================
> Connor McDonald
Thank you Connor, I'll put in in the 'what' parameter then...;-)
Regards, Joost Received on Mon Oct 08 2001 - 20:04:51 CEST