Need to understand how to implement Information Centric Analytics (ICA) SQL jobs from SQL Management Studio.
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:
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:
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.