SQL Agent - Schedule for 1st Business Day in month.

[Peager]

I have a need to schedule an SQL Job for the first 'business day' in a month. This would be Monday if the 1st fell on a Saturday or Sunday. Of course holidays also have the potential to mess this one up big time. My only thought was to create 12 '1st day of ...' schedules and update them manually once a year.

Does anyone have a more elegant solution. Would it be possible to 'push' schedules in from a client app?

Thanking all in advance,

Paul

 

[markros]

Check this

http://joecelkothesqlapprentice.blogspot.com/2007/06/working-days-calendar-in-t-sql.html

Anyway, you will need a Calendar table and then sp_StartJob to run the job.

PluralSight Learning Library