Sequence jobs - Sequencer

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Sequence jobs - Sequencer

Post by Kirtikumar »

Hi,

In my job sequence, there are many jobs. If any of the job fails or generats warning, I need to call an Abort job that updates one of the process status table as 'Failed' for the process.

The sequence has many job and from each we have added a custom condition (Abort or Warn) to the abort job.

To improve the readability of the job can we have back to back sequences?

E.g. Job1--->seq1--->seq2--->Seq3

Would it cause any prob? I tested it in some seq and was running fine. But just wanted to know if there is any well know prob in this.
Regards,
S. Kirtikumar.
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Re: Sequence jobs - Sequencer

Post by kwwilliams »

No problem having sequences calling sequences, or having sequences running back to back within another sequence.
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

Keith, it is Sequencer stage in job sequences I am talking about.
I should have mentioned it clearly in the first place itself. Sorry for that.
Regards,
S. Kirtikumar.
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Post by kwwilliams »

That is a little different than what I was answering. What would be the purpose of having a sequencer stage back to back with another sequencer stage? If your job literally looks like:


job --> sequencer 1 --> sequencer 2 --> sequencer 3


What benefit are the sequencers providing?
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Post by kwwilliams »

That is a little different than what I was answering. What would be the purpose of having a sequencer stage back to back with another sequencer stage? If your job literally looks like:


job --> sequencer 1 --> sequencer 2 --> sequencer 3


What benefit are the sequencers providing?
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

job does not exactly looks like this.

I have many stages in my jobs some called parallelly and sequentially.

If I just put one sequecer then many links cross each other as well as go over stages. To make the job readable I was thinking adding more sequencer stages.
Regards,
S. Kirtikumar.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Do whatever you like as long as it works and you get the 'all' versus 'any' setting correct in the Sequencers.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post by Kirtikumar »

Thanks Craig!
Regards,
S. Kirtikumar.
Post Reply