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

  • You could do it with a SQL Agent Job pretty easly. Just setup a pre-populated list of the 5th business day each month. The run an IF statement like below.

    IF (select * from 5thdayofmonth) = getdate()

    BEGIN

    -- Run report logic here.

    END

    Don't know of a way to do this in SSRS Scheduling Manager.

    Fraggle