Discussion Locked

MSSQL job/replication monitoring

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I'm looking for a reliable way to monitor SQL Server transactional replication as well as SQL Agent jobs. We have many servers using replication (and many SQL jobs), and it's never fun when users or developers call and say jobs or replication aren't running.

Does anyone have any useful ways to monitor these things?

Thanks in advance,
Brian

4 replies

by tbragsda

.
Look at Spotlight on SQL server. www.quest.com. Its a great product, and offer a free full working demo.

If you buy, send me a msg. I don't know the sales structure, but the rep I work with is a very good guy, and I would be happy to point some business his way.

TBR

by shdowflare

Hi,

We own Spotlight on SQL already and it looks to be an ad-hoc monitoring tool. How useful is it for replication and scheduled task notifications?

Thanks
Brian

by shdowflare

I use SiteScope (our monitoring tool) to watch the Event Viewer Application Log for SQLSERVERAGENT:208 messages. I had to make sure all SQL jobs (including those run by the replication agents) were configured to write to the Event Viewer on failure.

Thanks for the help.

-B

This discussion is closed to new replies.