SQL Server Performance

holiday schadule

Discussion in 'General Developer Questions' started by jasmin123, Jun 8, 2008.

  1. jasmin123 New Member

    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 .
  2. MichaelB Member

    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

Share This Page