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 jobsRelated Articles
Unable to see application after adding APM Insight .NET agent and getting "Failed to Load Profiler" error
The following are few reasons that might pose an interference with the APM Insight .NET agent profiling: 1. User Permission settings 2. Competing profilers/monitoring services If the installation is not done with administrative privileges, the ...I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?
By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...No Data for some of the metrics in MySQL 5.6/MariaDB 10.5
You might not be able to view the data for some of the metrics in MySQL or MariaDB monitors because the sys schema is not present in MariaDB version 10.5 and below and MySQL version 5.6 and below. As a result, Site24x7 MySQL individual database ...Troubleshooting steps if you don't see any data after installing the PHP agent
Problem statement: The APM Insight PHP agent has been installed, but no data is displayed in the Site24x7 web client. Troubleshooting steps: Ensure that you have installed both the PHP agent and the S247DataExporter. Check that you have restarted the ...My MySQL monitor shows "no data."
Troubleshooting tips when no data is shown in MySQL monitor: Please provide the credentials to the Site24x7 server monitoring agent using the following command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance Ensure the ...