Sequence Job Problem

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
patel_ds
Participant
Posts: 7
Joined: Thu Nov 02, 2006 6:24 pm
Location: Banglore-INDIA

Sequence Job Problem

Post by patel_ds »

We have a job design,

Master Sequence

Seq.1--> Seq.2--> Seq.3
Seq.1

Job No-->1 -->2-->3-->4-->5
Seq.2

Job No-->6-->7
Seq.3

Job No-->8-->9
In all Job Activity - property , we set OK as expression type.
The Problem is that, say if Job No. 4 has warning occurs ,then Seq.1 getting aborted -its not go to Job -5 -but its start running Seq.2 (Job No.6)
because Seq.1 -status is finished with OK status.
our requirement is to stop complete Master Sequence, if any warning occurs at any point of time.

Any idea would be appreciated.

Thanks in advance.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Do exception handling in all the sub sequences.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
patel_ds
Participant
Posts: 7
Joined: Thu Nov 02, 2006 6:24 pm
Location: Banglore-INDIA

Post by patel_ds »

JoshGeorge wrote:Do exception handling in all the sub sequences.
Can you give me little idea about it?
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Use an exception handler stage and link that to terminator stage. In terminator stage give the options according to your requirement. Goto job properties and check handle errors automatically options also. Use above said options according to your requirement.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
patel_ds
Participant
Posts: 7
Joined: Thu Nov 02, 2006 6:24 pm
Location: Banglore-INDIA

Post by patel_ds »

JoshGeorge wrote:Goto job properties and check handle errors automatically options also.
How to do this?
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Open the properties window of your sequence and check the 'Automatically handle errors' which is by default unchecked.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply