sql server replication: Monitoring agent status -- sql server replication

Monitoring agent status

Big Ern
5/7/2007 10:10:01 AM

sql server replication:

All -

I'm trying to setup a way to monitor the agent status for replication. I
tried using the built in "Alerts" and they are not working. I made sure that
they are enabled, but after enabling the Alerts, it does not show that the
event had ever happened when I check the history. I've made sure that the
alerts are enabled on the distributor and no where else.

So my next question would be is there a way programatically monitor agents?
I see the system view sys.dm_qn_subscriptions, but when I select * from it,

Re: Monitoring agent status

Big Ern
5/7/2007 12:40:02 PM

I am trying to monitor the failures and retries.

[quoted text, click to view]

Re: Monitoring agent status

Paul Ibison
5/7/2007 7:41:59 PM

Which event re you monitoring. I recall from another poster that we couldn't
get the on success alert running as the event couldn't get raised to the
windows log (couldn't change the message attributes, unlike in SQL 2000) ,
but I am not aware of any others.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: Monitoring agent status

Paul Ibison
5/8/2007 1:24:00 AM

This should be ok. Are you using SQL 2000 or 2005? I'd l'll take a look later
on, but for now as a stop-gap you could use a notification on the job itself.
Cheers,
Paul

Re: Monitoring agent status

Big Ern
5/8/2007 9:25:01 AM

We are using 2005. I'll try and give the notification on the specific job a
try and see if that works.

[quoted text, click to view]

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 in the sql server replication group.