changeling question for gurus

[MavrickStl]

This is changeling question for all the SQL server gurus out there.

Can some point me in the right direction to accomplish following task on 2000 SQL Server.

I am trying to figure out how to schedule a job, which runs on every third weekday of the month. I also would like to program it in such a way that it will skip holidays ( I would know all the holidays at the beginning of the year) if they fall on third weekday of the month and then run on next third weekday after the holiday.

Following is an example:

January 1’st, 2004 will be a holiday. So in my case for the month of January will technically start on January 2’nd, 2004 hence third working day for the month of January will be January 6th, 2004. I want my process to run on January 6th, 2004.

Thanks,

 

[nigelrivett]

Schedule it to run every day or whatever and at the beginning of the SP (or in a shell SP) calculate whether it should go further and if not exit.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.