Start a multiple instance job N times simultaneously

Alethesnake · Post by **Alethesnake** » Thu Dec 11, 2008 5:28 am

Hi All,
The aim is the one of the subject.
I have to run a job N times, according to the values (to be passed as parameters) saved into a file.

If I use the UtilityRunJob from a transformer having the file in input, the job is run N times but sequentially.
Is there a way to execute the instances simultaneously?

Thanks for any help.

Regards,

Ale.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Dec 11, 2008 5:57 am

Run os dsjob with nowait option

Alethesnake · Post by **Alethesnake** » Thu Dec 11, 2008 7:30 am

Thanks for your answer.
Is it possible to run the dsjob utility from datastage? I found the Execute Command stage for sequences, is it a suitable alternative to a shell script?

Is there an alternative way to make the simultaneous launches from a job (server/parallel)?

Thanks a lot.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 2:20 pm

You could make a copy of UtilityRunJob and modify it so that it does not wait for the job to finish. Of course, you then relinquish control, and can not readily throttle demand on the server.

Multiple, simultaneous execution of multi-instance parallel jobs, eh??

Of course, everyone knows that a DataStage server can deliver an infinite supply of CPU, memory and disk I/O resources!

Alethesnake · Post by **Alethesnake** » Fri Dec 12, 2008 9:19 am

That's interesting Roy, thanks for your suggestion.

I'll purpose it to my team.

Regards,

Ale.