Email when replication fails

  • I'm a relatively new beginner, but i already have to setup a system where an email is send when replication fails. So i read some things and:

    * set up database mail & necessary things

    * i'm able to send a test email

    * but ... i don't get the email when i (as a test) force the replication to fail (break network connection)

    What i did:

    * replication monitor

    * warnings and alerts tab => configure alerts

    * item "Replicatoin: agent failure" => configured it to send email to my address

    No email arrives when testing, and when i check the database mail log, no item is added.?

    Please, what am i missing? All i want is an email when the replication could not be done?

    _________________________________________
    Baller

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic850417-291-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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