Run the job mutliple times untill the condition is met
Posted: Fri Sep 24, 2010 9:08 am
Hi,
I have a situation where i have to query a table and look for a column.It is 'A' then proceed to another job.
I have to keep running the job until the column value is 'A'. Another process outside of etl updates this table..
Now how can i run the job every 5 min to check the value for "A". I have used start loop..>job activity..>end loop.
I'm checking for user status of this job as trigger...but the job is completed and it is exiting of the loop..How can i implement this in sequencer.
Thanks for your help!
I have a situation where i have to query a table and look for a column.It is 'A' then proceed to another job.
I have to keep running the job until the column value is 'A'. Another process outside of etl updates this table..
Now how can i run the job every 5 min to check the value for "A". I have used start loop..>job activity..>end loop.
I'm checking for user status of this job as trigger...but the job is completed and it is exiting of the loop..How can i implement this in sequencer.
Thanks for your help!