Errors loading job status details

Products

• Information Centric Analytics

Issue/Introduction

The following errors are displayed in the Risk Fabric Health dashboards Risk Fabric - SQL Job Status - Detail and SQL Job Status by Date:

Error loading Risk Fabric - SQL Job Status - Detail data

 

Error loading SQL Job Status by Date data

Environment

Release : 6.5.3

Component : Microsoft SQL Server

Cause

When a SQL Server Agent job has an invalid schedule (for example, no future instances scheduled), the job will fail and generate these errors in the Risk Fabric Health Dashboard.

Resolution

The reported behavior was caused by a defect that was addressed in 6.5.4. Upgrading to 6.5.4 will resolve this issue.

Alternatively, deleting invalid job schedules will temporarily address this issue.

Additional Information

The following query will identify any jobs scheduled without a future scheduled run date:

SELECT     sj.[name]
FROM       msdb..sysjobschedules AS sjs
INNER JOIN msdb..sysjobs AS sj
        ON sjs.job_id = sj.job_id
WHERE      sjs.next_run_date = 0;