Anyone have a current (as of v4.1) list of job status codes?

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Anyone have a current (as of v4.1) list of job status codes?

Post by admin »

Hello,

I am running DS v4.1, and had taken this list of job status codes on faith as being complete:

/* jobStatus values... from ardentdatastagedsdkincludedsapi.h dated 11/17/99 */

#define DSJS_RUNNING 0 /* Job running */
#define DSJS_RUNOK 1 /* Job finished a normal run
with no warnings */
#define DSJS_RUNWARN 2 /* Job finished a normal run with
warnings */
#define DSJS_RUNFAILED 3 /* Job finished a normal run with a
fatal error */
#define DSJS_VALOK 11 /* Job finished a validation
run with no warnings */
#define DSJS_VALWARN 12 /* Job finished a validation run
with warnings */
#define DSJS_VALFAILED 13 /* Job failed a validation run */
#define DSJS_RESET 21 /* Job finished a reset run
*/
#define DSJS_STOPPED 97 /* Job was stopped by operator
intervention (cant tell run type) */
#define DSJS_NOTRUNNABLE 98 /* Job has not been compiled
*/
#define DSJS_NOTRUNNING 99 /* Any other status */

However, I just had a job fail with a status code of 96. Since I have an After-Job Subroutine that needs to know all possible "failed" job status codes, I could really use the full list of possibilities and some indication of what they mean.

Thanks in advance,

Tracy Slack
Harland Financial Solutions
tslack@harlandfs.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Hi Tracy.

It may be that there are some discrepencies in the 4.1 documented codes, but moving forward, here are the codes from 5.1, one of which you ran into (96).

#define DSJS_RUNNING 0 /* Job running */
#define DSJS_RUNOK 1 /* Job finished a normal run with no
warnings */
#define DSJS_RUNWARN 2 /* Job finished a normal run with
warnings */
#define DSJS_RUNFAILED 3 /* Job finished a normal run with a
fatal error */
#define DSJS_VALOK 11 /* Job finished a validation run
with no warnings */
#define DSJS_VALWARN 12 /* Job finished a validation run
with warnings */
#define DSJS_VALFAILED 13 /* Job failed a validation run */
#define DSJS_RESET 21 /* Job finished a reset run */
#define DSJS_CRASHED 96 /* Job was stopped by some
indeterminate action */
#define DSJS_STOPPED 97 /* Job was stopped by operator
intervention (cant tell run type) */
#define DSJS_NOTRUNNABLE 98 /* Job has not been compiled */
#define DSJS_NOTRUNNING 99 /* Any other status */

We ship these as :

Ascential/DataStage/dsdk/include/dsapi.h
Ascential/DataStage/Projects/dstage/dsinclude/JOBCONTROL.H

The documentation (servjdev.pdf, section 13, DSGetJobInfo, DSJ.JOBSTATUS), should also match.

Ernie




-----Original Message-----
From: Tracy Slack [mailto:TSlack@harlandfs.com]
Sent: Wednesday, August 01, 2001 11:33 AM
To: datastage-users@oliver.com
Subject: Anyone have a current (as of v4.1) list of job status codes?


Hello,

I am running DS v4.1, and had taken this list of job status codes on faith as being complete:

/* jobStatus values... from ardentdatastagedsdkincludedsapi.h dated 11/17/99 */

#define DSJS_RUNNING 0 /* Job running */
#define DSJS_RUNOK 1 /* Job finished a normal run
with no warnings */
#define DSJS_RUNWARN 2 /* Job finished a normal run with
warnings */
#define DSJS_RUNFAILED 3 /* Job finished a normal run with a
fatal error */
#define DSJS_VALOK 11 /* Job finished a validation
run with no warnings */
#define DSJS_VALWARN 12 /* Job finished a validation run
with warnings */
#define DSJS_VALFAILED 13 /* Job failed a validation run */
#define DSJS_RESET 21 /* Job finished a reset run
*/
#define DSJS_STOPPED 97 /* Job was stopped by operator
intervention (cant tell run type) */
#define DSJS_NOTRUNNABLE 98 /* Job has not been compiled
*/
#define DSJS_NOTRUNNING 99 /* Any other status */

However, I just had a job fail with a status code of 96. Since I have an After-Job Subroutine that needs to know all possible "failed" job status codes, I could really use the full list of possibilities and some indication of what they mean.

Thanks in advance,

Tracy Slack
Harland Financial Solutions
tslack@harlandfs.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

I accidentally left out the other detail... 5.1 is the upcoming release that will become available in the next few months.

Ernie

-----Original Message-----
From: ernie.ostic@ascentialsoftware.com [mailto:ernie.ostic@ascentialsoftware.com]
Sent: Wednesday, August 01, 2001 2:30 PM
To: datastage-users@oliver.com
Subject: RE: Anyone have a current (as of v4.1) list of job status codes?


Hi Tracy.

It may be that there are some discrepencies in the 4.1 documented codes, but moving forward, here are the codes from 5.1, one of which you ran into (96).

#define DSJS_RUNNING 0 /* Job running */
#define DSJS_RUNOK 1 /* Job finished a normal run with no
warnings */
#define DSJS_RUNWARN 2 /* Job finished a normal run with
warnings */
#define DSJS_RUNFAILED 3 /* Job finished a normal run with a
fatal error */
#define DSJS_VALOK 11 /* Job finished a validation run
with no warnings */
#define DSJS_VALWARN 12 /* Job finished a validation run
with warnings */
#define DSJS_VALFAILED 13 /* Job failed a validation run */
#define DSJS_RESET 21 /* Job finished a reset run */
#define DSJS_CRASHED 96 /* Job was stopped by some
indeterminate action */
#define DSJS_STOPPED 97 /* Job was stopped by operator
intervention (cant tell run type) */
#define DSJS_NOTRUNNABLE 98 /* Job has not been compiled */
#define DSJS_NOTRUNNING 99 /* Any other status */

We ship these as :

Ascential/DataStage/dsdk/include/dsapi.h
Ascential/DataStage/Projects/dstage/dsinclude/JOBCONTROL.H

The documentation (servjdev.pdf, section 13, DSGetJobInfo, DSJ.JOBSTATUS), should also match.

Ernie




-----Original Message-----
From: Tracy Slack [mailto:TSlack@harlandfs.com]
Sent: Wednesday, August 01, 2001 11:33 AM
To: datastage-users@oliver.com
Subject: Anyone have a current (as of v4.1) list of job status codes?


Hello,

I am running DS v4.1, and had taken this list of job status codes on faith as being complete:

/* jobStatus values... from ardentdatastagedsdkincludedsapi.h dated 11/17/99 */

#define DSJS_RUNNING 0 /* Job running */
#define DSJS_RUNOK 1 /* Job finished a normal run
with no warnings */
#define DSJS_RUNWARN 2 /* Job finished a normal run with
warnings */
#define DSJS_RUNFAILED 3 /* Job finished a normal run with a
fatal error */
#define DSJS_VALOK 11 /* Job finished a validation
run with no warnings */
#define DSJS_VALWARN 12 /* Job finished a validation run
with warnings */
#define DSJS_VALFAILED 13 /* Job failed a validation run */
#define DSJS_RESET 21 /* Job finished a reset run
*/
#define DSJS_STOPPED 97 /* Job was stopped by operator
intervention (cant tell run type) */
#define DSJS_NOTRUNNABLE 98 /* Job has not been compiled
*/
#define DSJS_NOTRUNNING 99 /* Any other status */

However, I just had a job fail with a status code of 96. Since I have an After-Job Subroutine that needs to know all possible "failed" job status codes, I could really use the full list of possibilities and some indication of what they mean.

Thanks in advance,

Tracy Slack
Harland Financial Solutions
tslack@harlandfs.com
Locked