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 ...

    • 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 ...

    • No data for service and process in Windows server monitor

      If you see "No Data" for process and service metrics (such as CPU or memory usage of monitored services) in the Site24x7 Windows server monitor user interface, follow the troubleshooting steps below. Run PowerShell Commands Open PowerShell as ...

    • Where are Site24x7's physical data storage regions located?

      Site24x7's integrated data centers are located in the US, European Union, India, China, Australia, and Japan. All Site24x7 customer-related data are stored in these physical storage regions. Data Center Primary Data Center Disaster Recovery Data ...

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...