DSXchange

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.

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.