Scheduling the dependant jobs from different projects

vinodsri22 · Post by **vinodsri22** » Wed Jul 20, 2011 1:29 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jul 20, 2011 3:46 pm

Welcome aboard.

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

chulett · Post by **chulett** » Wed Jul 20, 2011 3:47 pm

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