I am unable to see any data for failed jobs in my database

I am unable to see any data for failed jobs in my database

If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission.

Data in the SQL performance monitor:

 

Data in the SQL insight monitor:


If the SELECT permission is not given, you will not be able to get the details of the jobs, and you might get the following error in your agent log file:

The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'.

Command:
Use the below command to provide the necessary permission:
use msdb;
GRANT SELECT TO "NT AUTHORITY\SYSTEM";

 

Customers also search this article for

There is a mismatch between the number of failed jobs shown and the actual number of failed jobs

    • Related Articles

    • How do I monitor an Oracle database hosted in a Docker container in the same machine?

      To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...

    • How to set up alerts for network device data collection issues

      When your network monitoring interfaces are not collecting data due to issues in the Network Module, you'll want to be alerted. To set up alerts, you need to add or edit the threshold and availability profile of the On-Premise Poller, which is used ...

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

    • Site24x7 Real User Monitoring (RUM) - Data Collection

      When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...

    • Understanding latency in data center operations

      Latency, measured in milliseconds (ms), is the time taken for a response to be generated by an application or service. Lower latency results in quicker responses. Latency can occur due to several factors like: Network traffic: High volumes can slow ...