How To:
How to use Scheduling parameters for Integrate locations
Scenario:
The Scheduling action controls how the replication jobs will be run by hvrscheduler. By default, when this action is not defined HVR schedules the capture and integrate jobs to run continuously. This means that after each replication cycle these jobs will keep running and wait for new data to arrive. HVR provides various scheduling parameters for capture jobs and integrate jobs.
In this article, we will see the various schedule parameters and how they can be configured for the integrate jobs.
1) /IntegrateStartAfterCapture: This parameter instructs that integrate job is run only when capture is triggered and there is new data to route to the target
2) /IntegrateStartTimes: This parameter instructs the Integrate to run at a specific user-defined batch or mini-batch intervals
3) /IntegrateOnceOnStart: This parameter instructs that integrate job will run for one cycle after trigger. It can be started manually with command hvrstart or through GUI. When integrate is not running it is represented in PENDING state
Resource Usage: If the customer wants to avoid the resource utilization for the empty integrate cycles this parameter is very useful since the integrate job only runs when there is data present to route.
Steps:
A) /IntegrateStartAfterCapture
Steps to configure /IntegrateStartAfterCapture
1) Define an action on the channel
- Right click on the channel and select Scheduling under New Action
- Clicking on the Scheduling action will show up an action box for Scheduling
2) Set up /IntegrateStartAfterCapture on Target group
3) Click on OK to set the action. This action will appear in the action pane.
B) /IntegrateStartTimes
Sample Use Case:
- When the customers are using the database for a reporting purpose then they might want the data to be static at the end of the day to perform reporting on it.
- Target resource utilization: This can help in reducing the resource utilization by avoiding running integrate job a certain times.
- The customers want to see only one change on the Target at the end of the day.
Steps to Configure /IntegrateStartTimes
1) Define action on channel
- Right click on the channel and select Scheduling under New Action
- Clicking on the Scheduling action will show up an action box for Scheduling which is like below
2) Set up the action /IntegrateStartTimes on Target Group
- Check box the parameter IntegrateStartTimes which will enable the browse button
- Clicking on the browse button will open up a dialog box StartTimes
3) In this step you have a choice to select the time intervals when you want integrate job to run. The highlighted Minutes, Hour, Day of Month, Month, Day tells when the job is scheduled to run. The grayed-out slots tell what is selected
- Here is a simple example which shows that the job is scheduled to run for every 10 minutes.
- Another example would be of a job scheduled to run once every hour
4) Click on OK to set the action. This action will appear in the action pane.
5) Perform Initialize for this action to take effect
C) /IntegrateOnceOnStart
Sample Use Case
- This parameter is typically used when the customers have the requirement to use a third party scheduler which can schedule jobs outside of HVR for all of their data movement and Integrations instead of HVR scheduler. (In this case, their scripts are going to contain commands to start the integrate job through the command line.)
Steps to configure /IntegrateOnceOnStart
1) Define action on the channel
- Right click on the channel and select Scheduling under New Action
- Clicking on the Scheduling action will show up an action box for Scheduling
2) Set up the parameter for Target group
3) Click on OK to set the action. This action will appear in the action pane.
4) Perform initialize for this action to take effect