Hello,
I need to make an infinity loop into a sequence job. Somebody know if that is posible? I have tried with startloop and endloop stages but in its properties I didn't find how to define it.
In my design I don't have a list or a fix number to limit the iterations into the loop, neither I have a file that I can use to wait for it.
Tnks.
Infinity loop into Sequence
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 21
- Joined: Thu May 31, 2007 8:58 am
You can't and trust me you don't want one. Make sure the job stops on some kind of a regular basis, even if it's only for a minute or two so files can flush and logs can purge, etc etc.
My last one like that ran 24x7 but it ran 23:55 minutes a day, shutting down at that time and then scheduled to start at midnight .
My last one like that ran 24x7 but it ran 23:55 minutes a day, shutting down at that time and then scheduled to start at midnight .
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can not implement imfinite loop in sequence,but it can have many iterations like 1 to 9999999. But as chullet said,sequences need to be stopped and retriggered again in limited period of time.
You can not implement imfinite loop in sequence,but it can have many iterations like 1 to 9999999. But as chullet said,sequences need to be stopped and retriggered again in limited period of time.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You should also build in a mechanism for notifying it to stop (or, at least, to stop at the next iteration). Typically a file coming into existence would serve as a "stop" flag. This can be checked easily with a Wait For File activity or an Execute Command activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.