Run Multiple instance with max of 2 instances.

[velayuthan]

Can someone guide me, "how to approach" on the following scenario in shell scripting.

Audit Table
-------------
ID Date Status
A 16-Apr Data Ready
B 15-Apr Data Ready
C 15-Apr Data Ready
D 16-Apr Data Not Ready
E 16-Apr Data Ready

I Have the above audit table which is updated every 1 hour.

Need to update the status as "In Progress " and run a datastage sequencer with ID (A and B ) and Date i.e using multiple instance.

If the above sequencer is completed for either A or B then the Status should be updated to "Completed" in Audit Table

and then the sequencer should be automatically trigerred for C and the Status should be updated to " In Progress" in Audit Table

i.e at any time the sequencer should run for max 2 ID's .

and so on.......

Thanks

[ArndW]

The "Job Activity" in job sequences has an automatic wait-for-job-to-end attached to it, so you would start your jobs by executing the appropriate command line dsjob. You could put a before-job call in the instance jobs that update the table with status of "In Progress" and an after-job call to update to "Completed".
You will need to find a mechanism to query your audit table from the job sequence (executing a command-line SQL would do the trick) and then for all jobs with a status of "In Progress" determine if they are actually still running or might have aborted and then decide how many jobs with status of "Data Ready" you can start.

[Sainath.Srinivasan]

What happens if one of your sequence fails ? Should the system stop or proceed for other rows ?

One option will be to have 2 instances - one for odd and one of even IDs. This way, you keep the flow simple and separate.

[chulett]

Why "in shell scripting"? That seems like a needless complication to me, I would do something like this in a Sequence or more likely hand coded "job control" code.

[velayuthan]

In case if the Audit Table has more record and if we need to run a maximum of 4 instances .how ca we achieve through loop ?

[ray.wurlod]

Use a Nested Condition activity to determine how many instances are already running. On second thought, a Routine activity may be easier for accomplishing this task.

[velayuthan]

Hi
can any one help me to run this 4 instances parallely at a time through scripts

[ray.wurlod]

I just did! Only run another instance when there are eligible candidates to run and there are fewer than four jobs already running.

[vivekgadwal]

Hi
can any one help me to run this 4 instances parallely at a time through scripts

Is there a reason you are stressing on scripts? As suggested by many here, you can achieve what you described in your first post without using scripts (as in shell scripts...)