RiskFabric processing details

Products

• Information Centric Analytics

Issue/Introduction

What methods are available for looking-up the details, status, and history of Information Centric Analytics's (ICA) nightly RiskFabric Processing and RiskFabric Intraday Processing jobs?

Environment

Version : 6.x

Resolution

Information about the details, status, and history of ICA's processing jobs can be viewed in the Risk Fabric console and by using SQL Server Management Studio (SSMS).

Risk Fabric console

• Admin > Integration > Job Status
• Dashboards > Risk Fabric Health

The Job Status dashboard displays the current status, last run outcome, and last run duration details of RiskFabric processing and Integration Wizard jobs. Jobs may be started and stopped from this dashboard. This dashboard is generally only made available to administrators.

The Risk Fabric Health dashboard provides the same information as the Job Status dashboard but cannot be used to start or stop jobs.

SSMS

1. Connect to the Database Engine hosting the RiskFabric relational database
2. In Object Explorer, navigate to SQL Server Agent > Jobs
3. To view job step details, follow this procedure:
   1. Double-click the RiskFabric Processing job or the RiskFabric Intraday Processing job
      The Job Properties - <job-name> window opens
   2. Click the Steps page
4. To view job step history, follow this procedure:
   1. Right-click the RiskFabric Processing job or the RiskFabric Intraday Processing job and select View History
      The Log File Viewer - <hostname> window opens

The following scripts can also be executed in SSMS to view job details and return job step history.

EXEC msdb.dbo.sp_help_job @job_name = 'RiskFabric Processing';

EXEC msdb.dbo.sp_help_job @job_name = 'RiskFabric Intraday Processing';

DECLARE	@timeframe int = 0;  /* Replace 0 with an integer to limit the range of days to return; otherwise, all retained log history will be returned. */

SELECT      h.instance_id "InstanceID",
			j.[name] AS "JobName",
            s.step_id AS "StepID",
            s.step_name AS "StepName",
            h.[message] AS "Message",
            msdb.dbo.agent_datetime(run_date, run_time) AS "RunDateTime",
            ((h.run_duration/10000*3600 + (h.run_duration/100)%100*60 + h.run_duration%100 + 31 ) / 60) AS "Minutes",
			CASE
				WHEN h.run_status = 0 THEN 'Failed'
				WHEN h.run_status = 1 THEN 'Succeeded'
				WHEN h.run_status = 2 THEN 'Retry'
				WHEN h.run_status = 3 THEN 'Cancelled'
				WHEN h.run_status = 4 THEN 'In Progress'
				END AS "Status"
FROM        msdb.dbo.sysjobs AS j
INNER JOIN  msdb.dbo.sysjobsteps AS s 
        ON  j.job_id = s.job_id
INNER JOIN	msdb.dbo.sysjobhistory AS h WITH (NOLOCK)
        ON  s.job_id = h.job_id AND
            s.step_id = h.step_id AND
            h.step_id <> 0
WHERE       (
                j.[name] = 'RiskFabric Processing' OR
                j.[name] = 'RiskFabric Intraday Processing'
            ) AND
            CAST(msdb.dbo.agent_datetime(run_date, run_time) AS date) >= CAST(GETDATE()-@timeframe AS date)
ORDER BY    h.instance_id;