Tringger n instances of a job parallely

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Tringger n instances of a job parallely

Post by samyamkrishna »

Hi All,

I would like to trigger multiple instances of a job say 'n' times.
I need 'n' to be a dynamic value which i can choose at run time.

How do i do this?

Regards,
Samyam
clmhwyfe
Premium Member
Premium Member
Posts: 42
Joined: Mon Jun 18, 2012 1:39 pm

Post by clmhwyfe »

Use a start and end loop activity with the counter value as a parameter, You pass the required value at runtime and the job would loop from 1 to n.

Use the counter value as the INV_ID while calling the parallel job.

Thanks
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Post by samyamkrishna »

Thanks for your reply.
The loop will call it sequentially one after another.

I need it to be triggered parallely.

Regards,
Samyam
ShaneMuir
Premium Member
Premium Member
Posts: 508
Joined: Tue Jun 15, 2004 5:00 am
Location: London

Post by ShaneMuir »

You would either have to write a custom routine or call the jobs from the command line.

It depends entirely on what sort of job monitoring you want to do.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could use the loop, but use an Execute Command activity to request the job to be run as a nohup background process via the dsjob command line.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
naveenkumar.ssn
Participant
Posts: 36
Joined: Thu Dec 03, 2009 9:11 pm
Location: Malaysia

Post by naveenkumar.ssn »

Hi,

Keep as much instance as you wanted to run in between the start loop and the end loop ...use a static (harcoded) invocation id and then run the sequence

Example : if you wanted 8 parallel jobs to run


SL(StartLoop)------{8 instance of the same job with hardcoded invocation id} .... EndLoop

When you give the number of instance you wanted to run ..divide it by no. of instance you have kept(in the above example its 8)

Regards
Naveen
Naveen Kumar
Datastage Consultant
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Post by samyamkrishna »

Thanks All for your replys.

I am going temporarily with the parallel seqeunce in a loop.
Also working on the script.

PS: The scripts is becoming bigger and bigger everytime i test it. :lol:

regards,
Samyam
Post Reply