January 20, 2010 at 6:18 am
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
January 20, 2010 at 5:35 pm
Did you set up the SQL Agent settings?
Right click on SQL Agent > Properties > Alert System
Check Enable Mail Profile
Select Database Mail from the Mail System dropdown
Select the profile you created from the Mail Profile dropdown
Check the box for Include body of e-mail in notification message
Click OK
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply