Reporting on Maintenance plans

  • Merry Christmas!

    On the maintenance plan tab, REPORTING, is it possible to email the reports to more than 1 operator? if so, how is this done

    Thank you,

    Juanita

  • Never setup an operator as a person.

    Setup a distribution list in Exchange and use that as the list in SQL. Prevents points of maint if the dba changes. The network guys should "copy" the current dba account for the new one, which should get your emails correctly sent.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Steve,

    Thank you so much for that suggestion. I'm having that done immediately.

    Juanita

  • Just for the record (for those of us in small shops). Set up a new Operator,

    in the e-mail field select the users to be e-mailed (assuming Outlook).

    The users will then be listed with a semicolon seperating the users.



    Everett Wilson
    ewilson10@yahoo.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply