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
Issue about Job Status code
Moderators: chulett, rschirm, roy
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.
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
"You can never have too many knives" -- Logan Nine Fingers