locked
SQL Management Pack RRS feed

  • Question

  • Hello,

    under Monitoring > Microsoft SQL Server > SQL Agent

    SQL Agent Job State is EMPTY should I not see all Jobs existing under SQL Server Agent on each server?

    SQL Agent State is displaying all Agents.

     

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
    Saturday, June 25, 2011 12:33 AM

Answers

  • Hi Felyjos,

    See here: http://blogs.technet.com/b/jimmyharper/archive/2009/06/05/sql-agent-job-discovery-not-working.aspx


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Graham Davies Sunday, June 26, 2011 8:06 PM
    • Marked as answer by Felyjos Monday, June 27, 2011 4:23 PM
    • Unmarked as answer by Felyjos Tuesday, June 28, 2011 4:15 PM
    • Marked as answer by Felyjos Tuesday, June 28, 2011 9:20 PM
    Saturday, June 25, 2011 6:57 AM

All replies

  • Hi Felyjos,

    See here: http://blogs.technet.com/b/jimmyharper/archive/2009/06/05/sql-agent-job-discovery-not-working.aspx


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Graham Davies Sunday, June 26, 2011 8:06 PM
    • Marked as answer by Felyjos Monday, June 27, 2011 4:23 PM
    • Unmarked as answer by Felyjos Tuesday, June 28, 2011 4:15 PM
    • Marked as answer by Felyjos Tuesday, June 28, 2011 9:20 PM
    Saturday, June 25, 2011 6:57 AM
  • The guide is a horrible thing to waste :)
    Microsoft Corporation
    Monday, June 27, 2011 3:58 PM
  • Hello,

    I have imported the Management Pack http://blogs.technet.com/b/jimmyharper/archive/2009/06/05/sql-agent-job-discovery-not-working.aspx and enabled Discover SQL 2008 Agent Jobs (Custom) and Discover SQL 2005 Agent Jobs (Custom ) under Object Discoveries but it seems the thresholds of 6000 seconds is delaying the discovery, any log to review to be sure the process is on-going as I don't see any job under the SQL Agent State View?

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
    Tuesday, June 28, 2011 4:19 PM
  • it was timely delayed :) now I have all jobs ... afteer 4 hours...

    Thanks,

    DOm


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
    Tuesday, June 28, 2011 9:21 PM