I'm using transaciton immediate replication on SS 2000 SP4. The problem is
that replication will sometimes have problems, i.e. I'll go into Ent Mgr and
see the publisher is red and needs to resync'd. The standard alerts that it
is re-trying don't really work - I'd like to get an alert that tells me when
it goes to red in Eng Mgr, i.e. when it needs to be resync'd. How can I do
that? Is there a way to script that? Is there a third party tool that will
do that?
Paul Ibison - 23 Aug 2008 18:09 GMT
Not too sure why the alert doesn't work for you in SQL Server 2000, but I
enable email messages on the actual jobs themselves rather than the alerts.
You could add such a response on the distribution agent. Alternatively use
something like SQL Sentry to monitor all your jobs centrally.
HTH,
Paul Ibison (www.replicationanswers.com)