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
Controlling Multiple instance of a job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers