Enabling and Scheduling Information Centric Analytics SQL Jobs

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

Need to understand how to implement Information Centric Analytics (ICA) SQL jobs from SQL Management Studio.
 

Resolution

When ICA is installed, several SQL jobs are created on the SQL server that hosts the RiskFabric database.  The primary purpose of these jobs is to import data from different integration sources as well as process that data.  The main ICA SQL job is the RiskFabric Processing job which is not enabled by default.  To enable the job, simply do the following:

1. Open SQL Management Studio
2. Connect to the SQL Server hosting the RiskFabric database
3. Navigate to the Jobs folder under the SQL Server
   
4. Right-click on the RiskFabric Processing job and select Enable
   

Aside from enabling the job, the schedule of the job execution may also require modification depending on mostly environmental factors.  By default, the RiskFabric Processing job is scheduled to execute at 12:15 AM daily.  To modify the schedule of the RiskFabric Processing job, do the following:

1. Open SQL Management Studio
2. Connect to the SQL Server hosting the RiskFabric database
3. Navigate to the Jobs folder under the SQL Server
   
4. Right-click on the RiskFabric Processing job and select Properties
   
5. In the Job Properties window, select the Schedules page
   
6. Select the job schedule in the Schedule List and click on the Edit button
7. In the Job Schedule Properties window, adjust the job execution schedule accordingly
   
8. Click on OK to save the schedule and close the Job Schedule Properties window
9. Click on OK in the Job Properties window to save the schedule modification and close the Job Properties window

During the first few days of the RiskFabric Processing job execution, gather metrics around execution times to determine the optimal schedule for the execution of the job.  Note that the more integration sources and data, the longer the execution of the job. 

Other than the RiskFabric Processing job, there is another job with a similar purpose.  The RiskFabric Intraday Processing job also does data processing but at a smaller scale.  It only processes a subset of the data for the purpose of having critical data in ICA be as close to real time as possible.  By default, the RiskFabric Intraday job is also disabled.  Once enabled, by default, it is scheduled to run every two hours from 11 AM to 8 PM.  Depending on the environment, this may or may not be enabled.