Re: dbms_job on workdays
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 08 Oct 2001 18:34:03 +0100
Message-ID: <3BC1E38B.69D1_at_yahoo.com>
end;',rest_of_parms);
Date: Mon, 08 Oct 2001 18:34:03 +0100
Message-ID: <3BC1E38B.69D1_at_yahoo.com>
Joost Bataille wrote:
>
> Hello everyone,
> does any of you how to instruct dbms_job to only run on workdays. Should be
> something in the interval parameter...
>
> Regards, Joost
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 http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Mon Oct 08 2001 - 19:34:03 CEST