SQL Replication Monitoring
Hi All, first post on the forums.
I'm trying to setup some monitoring of our MSSQL replication to try and keep a track and see when it fails or issues crop up.
I've tried to create a da...
Forum Discussion
If you can construct the connection string to get into the database and you can run the procedure as part of a query (not a SQL guy, so not sure how that works), you might be better off making a JDBC DataSource. That way you skip the coding altogether.
As for AD failing, exactly what are you looking to see as instances on the device? Would you see each database because your procedure will output the replication status of each database? Or is it a server level thing? If it's a server level thing, you don't need active discovery at all. If you will be monitoring each db's replication status, then each DB would need to be discovered.