DSXchange

Hi All,

We have developed two ETL processes A & B and now planning to schedule them. One ETL process is dependant on the other and they reside in two different projects. I have to schedule them such a way that process B should start only after Process A has finished. If both of them co-exist in the same project, we can put them in a single sequence and shcedule the sequence. But, if the dependant jobs are located in different projects, then I have no clue how to schedule them to run one after the other.

Can you please suggest me any solution for this? Your feedback is greatly appreciated.

thanks

Vinod

Welcome aboard.

One way is to execute the remote job via the dsjob command in an Execute Command activity in your sequence.

... make sure you use one of the wait options, "-jobstatus" would be preferred here in my humble opinion.