SQL Server Job Notification

  • Is there a way for email notification for both success and failure?

    Thanks

  • Sure. On the Notifications tab, just select "On Completion", instead of either "On Failure" or "On Success". There's a drop-down for it right after where you put in the person/group to send the e-mail to.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • One thing I would suggest - email on failure only. You'd be surprised how de-sensitized you will become to the influx of emails, especially if 99.9% are successes. If the emails are only on failure, which would probably mean some kind of reaction on your part, you'd know immediately that you had to do something to correct the situation.

    -- You can't be late until you show up.

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

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