Controlling Multiple instance of a job

[Maximus_Jack]

Hi

A job has to run in multiple instance taking the tablenames from a flat file as the invocation ID, but at any point there should not be more than 5 instances of the job, i have written a script where the job picks the table name and runs in multiple instance, but couldn't figure out how to control the number of instance

is there any way to do it?

cheers
MJ

[chulett]

Your script would have to count the number of times the job had been launched and stop at 5. You could also monitor the number running and when it drops below 5, launch more until it is back at 5. Repeat until you run out of table names.