Post reply

how can I have a failed job notification be emailed to more than one person

  • September 4, 2018 at 10:58 am

    #362634

    Hi,

    in SQL Server, how can I have a failed job notification be emailed to more than one person?

    Thank you

  • September 4, 2018 at 11:23 am

    #2004397

    Create an operator with multiple email addresses and use that in the job notification.

  • September 4, 2018 at 11:24 am

    #2004398

    The best way is to mail it to an email distribution list, which will then email it to the appropriate people.  It's usually much easier to adjust a distribution list than it is to modify jobs.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • September 4, 2018 at 11:34 am

    #2004399

    Okay thanks

  • September 4, 2018 at 12:15 pm

    #2004409

    Sreekanth B - Tuesday, September 4, 2018 11:23 AM

    Create an operator with multiple email addresses and use that in the job notification.

    Be aware, the operator line only has so many characters.If you need to notify more than 3 or 4 people, Drew's solution is the best for your needs.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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