Monitor transactional replication. -- sql server replication

Chen
4/27/2007 11:58:00 AM

Hi,
I want via email to monitor transactional replication status such as still
running, have some problem during retry, or re-initialize, etc. instead of
login to Microsoft SQL Server Management Studio in SQL Server 2005 (SP1). I
think those information should get from msdb, does anyone done that before?
Regards,

Chen
4/27/2007 1:42:00 PM

Hi Paul,

Thanks a lot for reply.
Can you take about details how to do those alerts?

Regards,
Chen

[quoted text, click to view]

Paul Ibison
4/27/2007 9:13:50 PM

Shouldn't have to do anything unusual here - you can use the replication
alerts for this:

a.. Replication: agent success

a.. Replication: agent failure

a.. Replication: agent retry

and have them send emails.

HTH,
Paul Ibison

Paul Ibison
4/27/2007 10:01:10 PM

This should help: http://msdn2.microsoft.com/en-us/library/ms152496.aspx
rgds,
Paul Ibison

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 : Monitor transactional replication.