Replication Monitoring

SQL Server 2000 EE.
What is the best way to monitor replication and have it send an email to me
as soon as it fails for some reason ? Is there a 3rd party utility for better
monitoring ?
Thanks.
You can utilize internal sql mail (if you have it configured). When
you setup your publications and subscriptions sql2000 will generate
jobs. In jobs properties you can set it to send you an e-mail if it
fails.
You can also write custom jobs to do this for you:
http://msdn2.microsoft.com/en-us/library/ms147874.aspx
T.
DXC wrote:
> SQL Server 2000 EE.
> What is the best way to monitor replication and have it send an email to me
> as soon as it fails for some reason ? Is there a 3rd party utility for better
> monitoring ?
> Thanks.
|||There are some built-in alerts for replication monitoring. In particular
there is the "Replication: agent failure" alert - you could enable this and
on the response tab select an operator to notify. For a more granular
approach you could identify the replication jobs themselves and define
operators to send emails to if the job fails.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .