Running a job when an existing job finishes

PhilHibbs · Post by **PhilHibbs** » Thu Mar 24, 2005 9:14 am

I have a job running. I want another job to start when it finishes. Am I doomed to hitting refresh in DataStage Director?

ArndW · Post by **ArndW** » Thu Mar 24, 2005 9:39 am

Phil,

you can always use a job sequence to do this, that is your easiest solution.

PhilHibbs · Post by **PhilHibbs** » Thu Mar 24, 2005 9:50 am

ArndW wrote:Phil,

you can always use a job sequence to do this, that is your easiest solution.

I don't think that helps when the first job is already running.

chulett · Post by **chulett** » Thu Mar 24, 2005 10:00 am

Well, then it sounds like you are doomed.

chucksmith · Post by **chucksmith** » Thu Mar 24, 2005 11:00 am

You could write some job control to call DSAttachJob and DSGetJobInfo to return the status of the currently running job. When the status is DSJS.RUNOK, you can start your next job.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 24, 2005 11:05 am

You also need a DSWaitForJob

dsxuserrio · Post by **dsxuserrio** » Sat Mar 26, 2005 3:27 pm

Looks like it is an adhoc requirement before close of business before going home.

You can try this

Code: Select all

l
$DSHOME/DSEngine/bin/dsjob -jobinfo $PROJECT $JOBNAME | grep "Job Status"  
Use a sleep and repeat every 10 seconds.
If the result is Run With Warnngs " or whatever you decide accordingly and kick off the next job.