RE: sqlplus question

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 28 Jan 2002 16:39:06 -0800
Message-ID: <F001.003FE01D.20020128155521@fatcity.com>

> -----Original Message-----
> From: lhoska_at_calibresys.com [mailto:lhoska_at_calibresys.com]
>
> But there is a little detail I failed to mention. My rundays
> suppose to
> skip weekends( that is easy) and certain holidays.
> My OS is Windows NT.
> Any suggestion is greatly appreciated.

Can you use dbms_job? If so, keep the list of holidays in a database table. Have the stored procedure re-submit the job at the beginning of the procedure, and skip week-ends by checking to_char (sysdate, 'D') and holidays by checking in your holiday table. Received on Mon Jan 28 2002 - 18:39:06 CST