Job Sequencer Problem

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
arunverma
Participant
Posts: 90
Joined: Tue Apr 20, 2004 8:20 am
Location: MUMBAI
Contact:

Job Sequencer Problem

Post by arunverma »

I have created one job sequencer where I am using job activity to call another job and that will triggred depend user status condition .

i.e .

UserStatus- (Conditional) = "Ok" Or "Warning" .

This means if Job1 give warning or Ok then triggre next job , but it is also trgring when Job No 1 Aborted .

Pl. help me how to handle this problem .


Regards

Arun Verma
Arun Verma
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Do you want literally USERSTATUS to be "Ok" or "Warning" because your first job does something to explicitly set it, or do you mean just the normal job status of ok or warning? :?

How are you setting the User Status? If that's really what you are using, then I'd suggest first thing in the job setting it to something else - like 'Abort' and then only set one of the other two when the job finishes.

In case you mean the normal Job Status, then use a 'Custom - (Conditional)' trigger:

Code: Select all

StageName.$JobStatus=1 Or StageName.$JobStatus=2
1= Ran Ok
2= Ran with Warnings
3= Aborted

Etc.
-craig

"You can never have too many knives" -- Logan Nine Fingers
arunverma
Participant
Posts: 90
Joined: Tue Apr 20, 2004 8:20 am
Location: MUMBAI
Contact:

Post by arunverma »

Thanks chulett,

As per your suggestion , I have implemented in my application , now it's working fine .

Thanks and Regrards

Arun Verma
Arun Verma
Post Reply