Put a timer on a sequencer

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
SPA_BI
Premium Member
Premium Member
Posts: 36
Joined: Tue Aug 29, 2006 8:01 pm
Location: Melbourne

Put a timer on a sequencer

Post by SPA_BI »

Hi,

I have this sequencer which kicks off several jobs. I need a routine (let's call it SendWarning()) to be called if the said sequencer runs for more than 7 minutes. Any suggestion as how this could be done?
from SPA_BI
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

You can achieve it by introducing a sleep command in your routine.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the sequencer an "any" or "all" sequencer?

Possibly, downstream of the sequencer, you need to create a loop for each job, that iterates for no more than your specified interval, sleeping (or napping) for small intervals in between checking whether the job's status is still "running". Suggestion: make the interval a parameter; if you hard code it Murphy's Law says you'll need to change it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply