Home Forums SQL Server 2005 Administering Custom SQL Agent job schedule to run on the 5th working day of each month RE: Custom SQL Agent job schedule to run on the 5th working day of each month

  • Agreed, you'll have to use a calendar table and a simple if statement to block / let the subscription run.

    Keep in mind that those jobs are rebuilt every time the subscription changes (this includes password update).

    So that solution can get annoying really fast if it's not properly scripted.