How to monitor SQL Agent jobs using the SQL Management Pack and OpsMgr

<!--[if lt IE 9]>

<![endif]-->

Comments

• Anonymous
  January 01, 2003
  I was wondering; this seems trivial however does not seem to be working for me.   I'm trying to setup the job monitor (not rule), which I've set appropriately as you've stated above but it does not work when using a dynamic group containing agent job objects.  It does however work when I enable it on an individual job basis; same as those listed in the dynamic group.   I have many jobs across the enterprise and those populated with a specific category are the ones we want to alert which is what the dynamic group is for.   Have you come across this issue before?

• Anonymous
  November 05, 2013
  Hello, Do you have the XML configuration after implementation such a unit monitor? Thanks, Ravi

• Anonymous
  January 03, 2014
  Pingback from Microsoft – Preparing for free exam 74-409 Server Virtualization with Windows Server Hyper-V and System Center | blog.bjornhouben.com

• Anonymous
  January 03, 2014
  Pingback from Microsoft – Preparing for free exam 74-409 Server Virtualization with Windows Server Hyper-V and System Center | blog.bjornhouben.com

• Anonymous
  September 10, 2014
  really Its very Helpful.
  

• Anonymous
  July 25, 2015
  The comment has been removed

• Anonymous
  November 29, 2015
  Hi Kevin,
  Could you please help me out in genrating sql long runing job with an job name i have configured it to generate long running job successfully.
  Am also getting all management server resource poll unavailable error. Requst ;you to kindly help me to resolve this issue

• Anonymous
  January 04, 2016
  One issue I have noticed is that if an SQL Agent Job is disabled SCOM will still Alert on it based on last run status. Discovery should be smart enough to remove this job from SCOM inventory.

• Anonymous
  February 24, 2016
  Is it possible to monitor the SQL logs in SCOM 2012 R2