Risk Fabric Health Dashboard does not display job step messages

Products

• Information Centric Analytics

Issue/Introduction

When you drill down into the Risk Fabric Health Dashboard, you notice the Message field is blank. Is that expected? What type of message should you expect to see?

Environment

Release : 6.x

Component : Dashboards

Resolution

The Message field should display the output recorded in the SQL Server Agent history log at the time the job last ran if the step was not successful. Specifically, the dashboard queries this table and column:

msdb..sysjobhistory.message

The dashboard will be updated to display the message content for all run statuses, including success, in a future release of ICA.