Home Forums SQL Server 2005 Business Intelligence Last Day of Month subscription for Shared SSRS schedule RE: Last Day of Month subscription for Shared SSRS schedule

  • November 3, 2008 at 5:41 pm

    #893347

    Angela Henry (10/31/2008)

    An update on this.

    I thought I had figured out how to do this. I set up a total of three separate shared schedules (not bothering with leap year at this point),

    1 - on the 30th day of April, June, September & November

    2 - on the 31st day of January, March, May, July, August, October & December

    3 - on the 28th day of February

    However this doesn't work as I expected because I'm still getting schedules executed on the 30th day of the month in months that have 31 days.

    Again, any insight would be helpful. I can't believe that I'm the only one that's trying to figure this out.

    Do you mean schedule jobs? Or ???

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)