SCOM question - Why is my "SQL Agent Job State" view empty?

  • I am working with System Center Operations Manager 2007 and, looking at the SQL Agent Job State view I find it empty.

    I added overrides in the Authoring pane to enable monitoring of SQL Server jobs, but the view is still empty.

    The SQL Agent State view, on the other hand, is populated as expected...

    What am I missing?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • You are almost certainly missing the correct permissions.
    Having sysadmin permissions will enable you to see the SQL Agent jobs. However, that is most likely too powerful a set of permissions.
    If I were you, I'd do some research to determine the minimum level of permissions required for you to see what you need.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply