We have two files to be loaded into TRIRIGA every day. The first file contains Organization records, and the second file contains triPeople records (Employees). So the second file should be loaded after all Organization records has been loaded. For each file, we have Job Scheduler (daily event) + ETL Job Item (transform file and load staging table) + DataConnect.
As I’ve understood it, for a daily event of job scheduler, we can’t specify the start time. So the two files will be consumed at the same time (midnight every day). Are there any dependent settings in DataConnect which allows us to prevent the DC_JOB of triPeople from being processed, before the end of loading of Organization records? Thanks in advance for your help!
I’m not sure if this will help, but if you use the same job names for both loads, and set JOB_RUN_CTL to 0 (single threaded), it will not start the second job until the first one has been completed.
[Admin: This post is related to the 05.20.16 post about scheduling a daily event with a specified time.]