Home Forums SQL Server 2005 SQL Server 2005 Integration Services How can automate report from sqlserver to be sent on email everyday. RE: How can automate report from sqlserver to be sent on email everyday.

  • November 17, 2016 at 1:46 pm

    #1913237

    MMartin1 (11/17/2016)

    Jeff Moden (11/16/2016)

    tnnelzo (6/20/2013)

    Hello!

    Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so that the email will be sent at 5:00 pm everday without having me to do it ....can anyone help me on this....thanks.

    Why not make an updateable spreadsheet that performs and external query so that your boss can refresh the data any time (s)he wants to?

    I think the boss may want to have historical information segmented out.

    Possibly. But the boss can save the spreadsheet everyday.

    As a bit of a sidebar and,as I know you know, so just saying it for others... daily spreadsheets aren't the place to store historical data/information. That's kind of stuff needs to be accumulated in a table so that you can actually do some stats across different time-frames.

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