Sequencer - Send STOP requests to all the running Jobs

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Your understanding is correct. The stage in question is the Terminator Activity stage and it can be triggered like that. You need to ensure the TA stage is actually getting called when your jobs abort...

Add a message to either the Logging Text on the General tab or to the Final Message Text on the Terminator tab and see if it ends up in the Sequence's log - that would be your biggest clue the stage is actually getting triggered.

Then on to the STOP requests, assuming the stage gets triggered - how long post abort do the other two jobs run before they finish? If they finish up rather quickly, the STOP request may not have time to take effect. It can also depend on what exactly the other jobs are doing, some activities are harder to stop than others.

If the TA stage isn't actually getting called, you'll need to check your trigger values and also any 'automatically handle' type options you've enabled in the Sequence job.

Rather than having three in the job (which is perfectly legitimate) you could consider another approach to handle this 'globally'. Add an Exception Activity stage to the job and link the Terminator Activity to that. This would give you one place where any aborted job could branch to and shut down everything else without having to have a spider web of links from all the Job Activity stages. Just something to ponder. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

As mentioned by Craid, the time taken by STOP signal to activate will the big impact, if the jobs are triggered in parallely. You assure about the stopping of process. It also depends on the volume of the data that been processed during that time. Which inturns decides the time of the job run.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

As mentioned by Craid, the time taken by STOP signal to activate will the big impact, if the jobs are triggered in parallely. You assure about the stopping of process. It also depends on the volume of the data that been processed during that time. Which inturns decides the time of the job run.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply