DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
franek
Participant



Joined: 05 Jul 2017
Posts: 4
Location: Warsaw
Points: 105

Post Posted: Fri Jul 14, 2017 10:07 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: TX
OS: Unix
Additional info: Sequence jobs design
I have multiple sequences that looks like this (let's call it SimpleSequence):

WaitForFile -> JobActivity(parallel) -> ExecuteCommandActivity -> JobActivity(parallel)

What I want to achieve:
Those jobs concern one functional area and I want to schedule them once. To avoid scheduling each job I have to aggregate them in one main sequence job. But my other requirement is to make them independent in the context of errors. Is it ok to aggregate sequences in another sequence? I was thinking about main sequence job which will be composed of multiple SimpleSequences like this:


WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path 1)


WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path 2)

(...)

WaitForFile -> JobActivity1(parallel) -> ExecuteCommandActivity -> JobActivity2(parallel) (call it path n)

Problem is, that if I'm using checkpoints and one JobActivity1 aborts, best scenario which I can configure is to finish started activities and then whole sequence aborts. This causes, that if in some path JobActivity1 fails, propably any of JobActivity2 will finish. When checkpoints are disabled, all paths finish and main sequence finishes ok - I would like it finish not ok. Do you have any suggestions on my design? Is this even possible or I have to schedule them separatelly?
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours