Replication Monitoring Help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication Monitoring Help

Hello Friends, If any of the agent[snapshot, log reader, Q reader, Distribution, Merge] fails, is there any command(sps) which will capture this information? I#%92m basically looking to read a log if the above agents fail and capture the record or a SP which would trigger a alert if it fails or some ‘key text#%92 in syslogs which I can query for the failure. Bharath Kumar
Why not output the agentlog – fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Check MSrepl_errors and MSmerge_errorlineage tables…and also see "Replication Stored Procedures (Troubleshooting) "… MohammedU.
Moderator All postings are provided “AS IS” with no warranties for accuracy.