Jimmy Harper's Operations Manager Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

Browse by Tags

Related Posts
  • Blog Post: 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, open SQL Server Managment Studio, connect...
  • Blog Post: 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 being discovered. Examining the event logs on...