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

  • August 22, 2010 at 7:20 pm

    #1210187

    SqlServerLover (8/22/2010)

    Can't you just run on the 1st day of the month at 12 am?

    This is how i have done as a solution of this problem .

    In my company, there won't be any transactions after 10 or 11 pm, so instead of running them on the last day of the month at 11 pm; i run them on the 1st day of the month.

    Most of the companies I worked for had a 24/7 policy... and transactions between 10 and 11 pm.

    The real key here is that you need to be safe. End of previous month runs should run correctly and without human intervention any time on any day for the whole month following.... IMHO that is. 😀 Heh... what good are computers if they require human interaction for things like previous month reports? :hehe:

    --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)