SQL Server Performance Forum – Threads Archive
Replication Monitoring HelpHello 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 –http://support.microsoft.com/kb/312292 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.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.