No data displayed for SQL jobs in the ICA console

Products

• Information Centric Analytics

Issue/Introduction

The following dashboard widgets on the Dashboards > Risk Fabric Health > Health Summary tab display no information:

• SQL Job Status - Summary
• SQL Job Status by Date
• Risk Fabric - SQL Job Status - Detail

The SQL Job Status by Date graph displays the message "No data for SQL Job Status by Date"; the pie chart for the SQL Job Status - Summary widget is missing; and the Risk Fabric - SQL Job Status - Detail table is blank. Adding, changing, or removing filters has no effect.

Cause

The widgets on the Dashboards > Risk Fabric Health > Health Summary dashboard query the tables msdb.dbo.sysjobs, msdb.dbo.sysjobschedules, and msdb.dbo.sysjobhistory. When SQL Server Agent jobs are managed by a third-party utility, the schedule-related columns required by these queries return NULL values. Consequently, no job details are displayed on the Health Summary dashboard.

Resolution

When a third-party application is used to manage and run SQL Server Agent jobs, job statuses and history should be monitored and managed through the third-party application's interface or monitoring tools.