Get job status after using UtilityRunJob

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
eldonp
Participant
Posts: 47
Joined: Thu Jun 19, 2003 3:49 am

Get job status after using UtilityRunJob

Post by eldonp »

I have a requirement to pass down runtime parameters from a file to a job. I have this working in a sequencer by using the UtilityRunJob(jobname,param1=value1|param2=value2,rowlimit,warnlimit) notation inside a routine activity.

In this sequencer, I need to evaluate the success of the job and handle it appropriately (failed status vs otherwise). I can't get this working in the triggers as the routine activity returns a return value with the success of the transform - and not the job status.

Question is - how I establish the failure/non failure of the job within the triggers of the routine activity.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Never tried this, but the docs say you need to use UtilityGetRunJobInfo afterwards to find out what happened. One of the possible actions is JobCompletionStatus, which sounds like the one you need.
-craig

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