Issue about Job Status code

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
caola
Participant
Posts: 10
Joined: Tue Jul 24, 2007 3:42 am

Issue about Job Status code

Post by caola »

I got a weird issue on Job Status code in a sequence job.
In sequence report, job BC is run as "validate only". So if validating ok, it should return job status = 11, but it actually returns job status = 0(as I remember 0 means job running, but why here it shows as No error). So if I use BC.$JobStatus = 11 on the trigger, it doesn't go to invoke next job as I want.

Here's part of the log.
report..JobControl (DSWaitForJob): Job BC has finished, status = 11 (Validated OK)
report..JobControl (@BC): Job BC did not finish OK, status = 'No error'
report..JobControl (@BC): Report on job: BC

**************************************************
STATUS REPORT FOR JOB: BC
Generated: 2014-10-20 05:11:29
Job start time=2014-10-20 05:11:29
Job end time=2014-10-20 05:11:29
Job elapsed time=00:00:00
Job status=0 (No error)
Stage: BOX, 0 rows input
Stage start time=, end time=, elapsed=00:00:00
Link: insert, 0 rows
Stage: BC, 0 rows input
Stage start time=, end time=, elapsed=00:00:00
Link: insert, 0 rows
:)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't know why you are seeing a zero rather than the 11, you may need to go to support on that. What exact release are you on?

Mostly just wanted to point out that you should never hard code status numbers anywhere, including trigger expressions. Use the appropriate status text in your expression like DSJS.RUNOK or in your case DSJS.VALOK instead.
-craig

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