How do you prevent one DC job from starting before another?

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.]

Continue reading


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.