August 29, 2006 at 9:26 am
Hello DBA's!!
Is it possible to send an alert (email, netsend, etc) when distribution agent fails and consequently, stops?
I have a transactional replication working, but sometimes i get "General net error" and when i give for it, the agent is stopped. The more time i take, more difficult it's because more transactions are accumulated waiting to be forwarded.
So i need to be alerted!!
I need to be alerted!
I need!
HOW TO??
Thanks
CLaudia
Cláudia Rego
www.footballbesttips.com
August 30, 2006 at 10:30 am
The distribution agent (and all replication agents) runs as an agent job. If you have sql mail configured, set the job to notify you on failure. (Personally I like all my replication jobs to retry several times before failing).
If you don't have sql mail configured, you can write an application that uses SMTP and queries the msdb..sysjobhistory table, notifying of new failures.
Terry
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply