Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : Replication Alert not working


maxzsim via SQLMonster.com
5/18/2006 12:00:00 AM
Hi ,

I have setup Replication alert to send email to me while the agent failed or
retry from the Replication Monitor i can see my replication is either
retrying or fail but it did not seem to trigger the Replication Alert as the
count is still showing 0

is there any way to check why it was not triggered ?

appreciate ur advise

tks & rdgs

--
Hilary Cotter
5/19/2006 12:00:00 AM
The alert should be raised. It is possible that a certain class of failures
will not raise the alert. In this case you might want to add a job step that
is run on the previous set failure so that it raises an alert.

--
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]

maxzsim via SQLMonster.com
5/23/2006 3:58:12 AM
Hi ,

Do you mean to put in the job in the "Response" tab ?

I have actually "asked" the system to execute a job as well as to netsend me
in event of the "Replication Agent failure"

tks & rdgs

[quoted text, click to view]

--
Hilary Cotter
5/23/2006 9:46:23 PM
That's right!

--
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]

maxzsim via SQLMonster.com
5/24/2006 5:41:46 AM
Hi ,

But this is exactly what i have setup perviously and somehow it wasn't being
activated

tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com
AddThis Social Bookmark Button