DSXchange

Wow, that's one long sentence... and not a period in sight.

And 'OLTP' means what here? I don't mean what does it stand for, but rather what is the underlying database?

In other words, use a Sequence job to control the flow of the jobs and the dependencies between them. To handle the +x minutes delayed start time requirement, add a Routine Activity stage between the jobs that sleeps for the appropriate amount of time.

For 'knowledge of the product' one can always click on a poster's name and see how they ranked themselves when they setup their profile, hopefully they were being honest when they did so. And they keep it up-to-date. :wink: Now, as to the problem at hand (which I assume is related to the StartLoop q...

So... do you actually have a question or is this just an informational post?

'Actually running' how? Are rows being processed through the job? Describe your job - the stages used, etc.

Ah... I stand corrected.

As do I - with the exception of checkpointed Sequence jobs, they must abort in order to be restartable from the point of failure.

Apparently so, yes.

Check out the older but (from what I recall) more inclusive Ascential Tech Tip we posted on Kim Duke's website on his Tips page - it's at the bottom in the 'TwoTechTips' zip file.

Yes, not just can but must for the technique to work properly. And as you noted, the caching of the reference lookup needs to either be disabled, or 'locked for update' if you do cache it. I prefer the former, Ray seems to prefer the latter.

Sure, just use two separate hashed file stages with the transformer, not a single one with two different link types.

You need to abort the child sequence when a job it is running aborts for the 'master' to notice.

He did, actually.

P.S.: I've seen no difference in behaviour whether I tick "Create file" or not. DS always seems to create the hashed file if it does not already exist. Correct. Ticking 'Create File' just gives you the option to override the defaults used at creation time, plus access to the 'delete befor...