set up Email notification when transaction repl fails? -- sql server replication

Rich
10/5/2006 10:43:02 AM

Hello,

The other day our ISP lost our mac address (or something) and we lost
internet access. Along with that came our transactional replication failure
as the publisher DB could not reach the subcriber DB. The internet
connection got resolved shortly afterwards, and no customer was complaining
about access to our sites until we got a new customer this morning (2 days
later) who couldn't log on. So I saw that there was in fact a replication
failure (the new customer's login info not replicated). I restarted the
distribution agent and all was fne.

Does sqlsvr(2000) have a mechanism where I can be emailed when replication
fails? Transactional replication? If so, how can I set this up?

Thanks,

Rich
10/5/2006 12:11:02 PM

Thank you. Yes. I saw the alert for Agent failure. I have been spending
sometime since your suggestion setting up a profile on our exchange server.
This is a whole nuther issue for me which is going to take me a little while
to figure out (since I am not an Exchange mail server guy).

I guess I will be hanging out in the Exchange server group for a bit to
figure this out - unless you know the easy way to set up a profile on
Exchange server.

I am reading the following article at

http://support.microsoft.com/kb/263556/EN-US/

on how to configure sql mail, but I still need to set up the profile.

Rich

[quoted text, click to view]

Hilary Cotter
10/5/2006 2:21:26 PM

Have a look at replication alerts.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : set up Email notification when transaction repl fails?