Setting up the Task Scheduler for the Rapide Data Model
In order to run properly and in an automated manner, the synchronization and data load mechanisms of the Rapide data model rely on a task scheduling tool. Configured in the Admin Portal interface of the beqom TCM application, the task scheduler is a mechanism that enables you to automatically launch specific jobs, at a defined frequency.
Specifically, it is used to launch the following beqom Rapide processes:
Data model customization, i.e. the synchronization/unsynchronization of custom referential tables, computed columns and extended core payee fields. For data model customization, the task scheduler executes a stored procedure that checks whether an action has been requested in the Task Launcher - Synchronization grid, Action child grid (located under (Undefined variable: CompoVariables_WA_Alternate."Data") > Data Management > Data Model. If an action has been requested, then the objects listed in the Preview child grid of the Task Launcher - Synchronization grid are synchronized/unsynchronized.
Manual data load: in the context of the manual data load within the Rapide template, the task scheduler launches a stored procedure that checks if any action was requested in the Task Launcher - ETL grid, Action child grid (located under (Undefined variable: CompoVariables_WA_Alternate."Data") > Data Integration). If any action has been requested, then the data is loaded from the staging tables to the target tables.
API data load: the task scheduler launches a stored procedure that checks if any data load has been requested via API.
This is an note/information message.
As a best practice, beqom recommends that you configure the task scheduler before attempting any of the above mentioned operations.
Configuring the Rapide Task Scheduler
To configure the task scheduler to ensure a proper function of the processes mentioned above, configure the scheduler as follows:
Open the Admin Portal interface of the beqom TCM application, and then open the (Undefined variable: CompoVariables_AP.Admin).
Navigate to Functional Admin > Scheduler. The grid containing all the schedulers already defined in the system is displayed.
Click the + icon located in the lower-left corner of the grid. A new scheduler item is created and opened in the Scheduler tab.
In the Scheduler Name field, enter the name you want to give to the scheduler.
In the Scheduler Type field, select Recurring.
Check the Enabled box located at the right of the Scheduler Type field.
-
In the Frequency section, define the frequency parameters:
Frequency Type: define the recurrence of the task scheduler. Possible options are: Daily, Weekly or Monthly. For the purpose of this procedure, select Daily.
Recurs every: enter the frequency of the execution of the task scheduler. For the purpose of this procedure, enter 1. This will ensure that the task scheduler is run every day.
-
In the Daily Frequency section, define the number of times the procedure will be run each day:
Check the Occurs every radio button, and then enter 10 seconds in the subsequent fields.
In the Starting at field, enter the time of the day at which the recurrence starts. For the purpose of this procedure, enter 00:00:00.
In the Ending at field, enter the time of the day at which the recurrence ends. For the purpose of this procedure, enter 23:59:59. This will ensure that the email sender runs all day long at the defined interval.
-
In the Duration section, define the duration for which you want the scheduler to run
In the Start date field, leave the current date (which inserted by default by the system) or select the date at which you want the task scheduler to start running.
Check the No end date radio button. This will make sure that the task scheduler always runs. If you want to define an end date, check the End date radio button and then select the target date in the subsequent field.
Click the save icon, located in the lower-left corner of the property panel to save the definition of the task scheduler. The following figure illustrates the definition that you should see for the task scheduler:
Switch to the Events tab to configure the event that will be triggered by the task scheduler.
Click the + icon located in the lower-left corner of the event panel. A new event is added and the event definition panel is opened in the right-hand part of the application screen.
-
Define the parameters of the event:
In the Event Name field, enter the name that you want to give to the event.
In the Event Type drop-down list, select the type of event to be triggered by the scheduler. For the purpose of this procedure, select Stored Procedure. A new field is now displayed under the Event Type field.
In the Stored Procedure drop-down list, select the SP to be triggered. For the purpose of this procedure, select config_sp_task_launcher_scheduler.
Click the save icon located at the bottom of the event configuration panel. The task scheduler is now properly configured and ready to run.
This is an note/information message.
Now that you have configured the task scheduler, you can load data or create custom objects in the beqom Rapide Data model.
For more information about the data load procedure, refer to Loading Data Manually into the beqom Rapide Template and Loading Data into the Rapide Data Model Using Azure Data Factory.
For more information about the customization of the data model, refer to Extending the beqom Rapide Data Model.