> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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.
