locked
SQL job monitor RRS feed

  • Question

  • 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

  • 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

  • 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
  • Thanks Kevin.
    Monday, October 5, 2009 5:06 PM