i have 2 schadules in my job . one is regular and the other is holiday schadule. now I have created a table tholidaylist with holidays. sometimes we have holidays 2 days in a row and i want to disale both the schedules if the holidays are 2 days in a row and the next day when the proc runs i want to start the holiday schadule job to run and disable a regular schedule .
Are you trying to do this using SQL agent? Anway, you can program this in a code like VB and use something like my date function to find the Next holiday... See the link. http://www.sqlmag.com/Articles/ArticleID/97590/97590.html?Ad=1
