Job Sequence

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Job Sequence

Post by mydsworld »

In a Job sequence :

Job1 -> Job2

When I specify 'OK-(Conditional)' in the Trigger condition of Job1 and Job1 finishes with warning, does that mean Job2 will not start.

In other words ,

Is 'OK-(Conditional)' takes care of job finishes successfully with or without warning.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK means OK, finished without warnings. There's another trigger for that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

I want to start Job2 if Job1 finishes successfully with or without warning. I do not want to use Sequencer in between and use two different trigger conditions as you said.

Can I make the trigger condition of Job1 as 'Custom' and specify the following :

Job_Activity_0.$JobStatus = 'DSJS.RUNOK' Or Job_Activity_0.$JobStatus = 'DSJS.RUNWARN'
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sure, but you'd need to remove the quotes around the DSJS values for it to work properly.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

Thanks for that. Its working.

Have one more dbout. If I use Exception Handler stage in a Job sequence, how to capture the error messages etc from the Exception Handler stage. What stage shouild I put after Exception Handler to capture the error messages.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Any such messages will already be in the log, so it depends on what you mean by 'capture'. Email? Then a Notification Activity should be fine, I would think.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

Then where and how do we use the Exception Handler variables (like ErrSource, Errmessage etc).
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Honestly, never tried as I haven't needed them. If you 'Include job status in email' for Notification, you get everything I've ever needed. [shrug]

I would assume they could be used in any 'downstream' stage, have you tried using them in the body of a Notification email?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply