Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
0 comment(s) Post a comment
  • Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

SQL 2008 Agent Class

  • ID:  Microsoft.SQLServer.2008.Agent
  • Description:  Microsoft SQL Server 2008 agent component
  • Class Hierarchy: 
    Logical Entity
    Application Component
    Windows Application Component
    SQL Component
    SQL Agent
    SQL 2008 Agent

  • Attributes:  Public, Hosted
This monitor checks the status of the SQL Agent service for this instance of SQL Server. This monitor checks for long running SQL Agent jobs. SQL 2008 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job. Monitors Agent Job Duration. Microsoft SQL Server 2008 agent component All Microsoft SQL Server 2008 agent jobs.

Download diagram as a Visio file


Display Name Description
Account Name  
Agent Name  
Display Name Display name of monitoring object.
Service Name (Key)  

Discovered By

Name Description
Discover SQL Agent for a DB Engine This object discovery discovers the SQL Server Agent for an instance of SQL Server 2008 DB Engine. There will always be one SQL agent instance for each DB Engine instance.


Health Source
SQL 2008 Agent Hosts Agent Job SQL 2008 Agent Hosting
Entity Watched By Perspective Entity Reference

Health Target
SQL 2008 Database Engine Hosts SQL 2008 Agent SQL 2008 Agent Hosting

Class Knowledgebase

This class does not contain any summary.
External References
This class does not contain any external references.

See Also for SQL Server Management Pack

Downloads for SQL Server Management Pack

Post a comment
Comments to other elements of this Management Pack:
Article Message Posted By
We are providing a platform for those who want to join this profession.
writing jobs
shahid.afraid111@gmail.com at 10/29/2014 11:48:42 AM
Is Management Pack inventory available for SQL Server 2012 MP version
milmanfm@gmail.com at 9/23/2014 11:36:42 AM
Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQ
Due to over storage of SQL database files the memory allocation refuses and creates some errors which are responsible for SQL database inaccessibility. You must go through this to learn more about resolving solutions:- http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html
enriquemallon@gmail.com at 6/28/2014 10:10:17 AM
Database consistency errors found
I recommend you to read this article which serve you how get rid of this consistency error:- http://www.sqlrecoverysoftware.net/blog/fix-database-consistency-errors.html
elliswhite43@gmail.com at 5/10/2014 11:06:07 AM
Overview shantal@list.ru at 7/2/2013 11:57:28 AM
Where can i get the Management pack Inventory for SQL 2008
vivakhangloo@gmail.com at 4/4/2013 8:32:16 AM
According to the Pinpoint catalog, the SQL MP was updated to include SQL 2012 monitoring as of 4/2/2012. Do you have an ETA for when this MPwiki entry will be updated? Keep up the great work; thanks!
bdady@denaliai.com at 5/30/2012 2:47:22 PM
DB File Space
You should keep in mind that file-level monitoring works rather good now but in case of extremely loaded server (e.g. which works all the time about 99% of CPU) or you have really huge number of DBs and files (e.g. 500 databases consist of 1000-2000 files) - you should think about Database-level space monitoring.
legolasishe@mail.ru at 3/21/2012 1:39:09 PM
Overview shantal@list.ru at 11/4/2011 3:29:24 PM
Overview igrudina@viacode.com at 10/26/2011 4:12:53 PM