Looping in Sequencer

[sonia jacob]

Hi,

I have 2 jobs, JOB1, JOB2 that need to run sequentially. I have a PROCESS P1 that runs after JOB1 and before JOB2. I need to wait till P1 completes to trigger JOB2. No, P1 is not a DS job.

To know whether P1 has completed, I need to query agaisnt table to check for complete flag.

We have written routine that loops till the status becomes 'Complete'. Once the status is complete I come out of the routine and the next job JOB2 kicks off in the sequencer

Is there any better way to go about it?

Thanks in Advance.

regards,
Sonia

[ArndW]

It sounds like a good solution and is simple enough to withstand the test of production. If your routine has lengthy SLEEPs to wait and also has a maximum timeout so that it always will exit sometime then you are set.

[ray.wurlod]

A job sequence? JOB1 --> P1 --> ExecuteCommand --> JOB2

If P1 is an ExecuteCommand activity in its own right, then it might be wrapped in a script whose exit status can be tested, thereby avoiding the second ExecuteCommand activity.