locked
SQL job monitor RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am having SCOM SP1 environment. I have imported SQL MP. I just want to monitor some of the SQL jobs & not all.
    Is this possible in SCOM?

    -winadm
    Monday, October 5, 2009 1:01 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes.  SQL Agent jobs are not discovered by default. 

    Find the discovery for SQL agent jobs, and enable it only for the SQL agents that you care about.

    If there are particular jobs even on those specific SQL agents that you only want alerts on - and not all of them.... then create a group of critical agent jobs based on some criteria.  Disable the rules and monitors targeting the SQL agent job class, and then enable them (more specific) using this group of SQL agent jobs.
    • Marked as answer by winadm Monday, October 5, 2009 5:06 PM
    Monday, October 5, 2009 1:15 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes.  SQL Agent jobs are not discovered by default. 

    Find the discovery for SQL agent jobs, and enable it only for the SQL agents that you care about.

    If there are particular jobs even on those specific SQL agents that you only want alerts on - and not all of them.... then create a group of critical agent jobs based on some criteria.  Disable the rules and monitors targeting the SQL agent job class, and then enable them (more specific) using this group of SQL agent jobs.
    • Marked as answer by winadm Monday, October 5, 2009 5:06 PM
    Monday, October 5, 2009 1:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Kevin.
    Monday, October 5, 2009 5:06 PM