Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Discovery » SQL   (RSS)
Thursday, June 11, 2009 6:26 PM

SQL Database Properties Not Discovered

I ran into an issue recently where some SQL Databases were not showing any properties in OpsMgr, other than the database name: To get these properties, the database discovery script runs the “sp_helpdb” stored procedure against the database. To test this,
Posted by jimmyharper | 0 Comments
Filed under: , , ,

Attachment(s): DB_Discovery_debug_scripts.zip
Friday, June 05, 2009 3:36 AM

SQL Agent Job Discovery not working?

The SQL Server Management Pack includes an option to discover and monitor SQL Server Agent Jobs for SQL 2000/2005/2008. The Discovery for this is disabled by default: I ran into an issue recently where all Agent Jobs for specific SQL Servers were not
Posted by jimmyharper | 4 Comments
Attachment(s): Custom_SQL_Agent_Job_Discovery.zip
 
Page view tracker