List of Job Statuses?

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

List of Job Statuses?

Post by admin »

Does anyone know where I can get a list of job statuses and what they mean? I know that a job status of zero means it completed successfully, but I would like to know what they other statuses are as well, since I have a job that appears to have run successfully, yet I get statuses other than zero for this job.

Thanks for your help!

Lola

Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

This is in jobcontrol.h.

* Possible return values for token DSJ.STATUS:
Equ DSJS.RUNNING To 0 ;* This is the only status that means the
job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no
warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal
error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no
warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with
warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator intervention
(cant tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status



Kenny



-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:00 PM
To: Datastage (E-mail)
Subject: List of Job Statuses?


Does anyone know where I can get a list of job statuses and what they mean? I know that a job status of zero means it completed successfully, but I would like to know what they other statuses are as well, since I have a job that appears to have run successfully, yet I get statuses other than zero for this job.

Thanks for your help!

Lola

Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Kenny --

Thanks for the quick response. This is probably a dumb question, but what is jobcontrol.h?

Thank you!

Lola

-----Original Message-----
From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyuhealth.org]
Sent: Thursday, June 07, 2001 12:18 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


This is in jobcontrol.h.

* Possible return values for token DSJ.STATUS:
Equ DSJS.RUNNING To 0 ;* This is the only status that means the
job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no
warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal
error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no
warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with
warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator intervention
(cant tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status



Kenny



-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:00 PM
To: Datastage (E-mail)
Subject: List of Job Statuses?


Does anyone know where I can get a list of job statuses and what they mean? I know that a job status of zero means it completed successfully, but I would like to know what they other statuses are as well, since I have a job that appears to have run successfully, yet I get statuses other than zero for this job.

Thanks for your help!

Lola

Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Lola,

JOBCONTROL.H has a lot of system definitions. They can be used for example to see that a job status of 96 is DSJS.CRASHED and means the job has crashed, or to see what the different statuses are so you know what to check for. In one job I have the line If (Status NE DSJS.RUNOK) and (Status NE DSJS.RUNWARN) then because I want to know if the job ran OK. DSJS.RUNWARN means the job finished normally but had warning messages.

In my system JOBCONTROL.H is in /ardt/Ardent/uv/projects/project_name/dsinclude/JOBCONTROL.H
project_name being whatever the project name is.


Kenny


-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:24 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


Kenny --

Thanks for the quick response. This is probably a dumb question, but what is jobcontrol.h?

Thank you!

Lola

-----Original Message-----
From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyuhealth.org]
Sent: Thursday, June 07, 2001 12:18 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


This is in jobcontrol.h.

* Possible return values for token DSJ.STATUS:
Equ DSJS.RUNNING To 0 ;* This is the only status that means the
job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no
warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal
error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no
warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with
warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator intervention
(cant tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status



Kenny



-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:00 PM
To: Datastage (E-mail)
Subject: List of Job Statuses?


Does anyone know where I can get a list of job statuses and what they mean? I know that a job status of zero means it completed successfully, but I would like to know what they other statuses are as well, since I have a job that appears to have run successfully, yet I get statuses other than zero for this job.

Thanks for your help!

Lola

Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Thank you very much!

Lola

-----Original Message-----
From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyuhealth.org]
Sent: Thursday, June 07, 2001 12:36 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


Lola,

JOBCONTROL.H has a lot of system definitions. They can be used for example to see that a job status of 96 is DSJS.CRASHED and means the job has crashed, or to see what the different statuses are so you know what to check for. In one job I have the line If (Status NE DSJS.RUNOK) and (Status NE DSJS.RUNWARN) then because I want to know if the job ran OK. DSJS.RUNWARN means the job finished normally but had warning messages.

In my system JOBCONTROL.H is in /ardt/Ardent/uv/projects/project_name/dsinclude/JOBCONTROL.H
project_name being whatever the project name is.


Kenny


-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:24 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


Kenny --

Thanks for the quick response. This is probably a dumb question, but what is jobcontrol.h?

Thank you!

Lola

-----Original Message-----
From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyuhealth.org]
Sent: Thursday, June 07, 2001 12:18 PM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?


This is in jobcontrol.h.

* Possible return values for token DSJ.STATUS:
Equ DSJS.RUNNING To 0 ;* This is the only status that means the
job is actually running
Equ DSJS.RUNOK To 1 ;* Job finished a normal run with no
warnings
Equ DSJS.RUNWARN To 2 ;* Job finished a normal run with warnings
Equ DSJS.RUNFAILED To 3 ;* Job finished a normal run with a fatal
error
Equ DSJS.VALOK To 11 ;* Job finished a validation run with no
warnings
Equ DSJS.VALWARN To 12 ;* Job finished a validation run with
warnings
Equ DSJS.VALFAILED To 13 ;* Job failed a validation run
Equ DSJS.RESET To 21 ;* Job finished a reset run
Equ DSJS.CRASHED To 96 ;* Job has crashed
Equ DSJS.STOPPED To 97 ;* Job was stopped by operator intervention
(cant tell run type)
Equ DSJS.NOTRUNNABLE To 98 ;* Job has not been compiled
Equ DSJS.NOTRUNNING To 99 ;* Any other status



Kenny



-----Original Message-----
From: Lola Ball [mailto:lball@netLibrary.com]
Sent: Thursday, June 07, 2001 2:00 PM
To: Datastage (E-mail)
Subject: List of Job Statuses?


Does anyone know where I can get a list of job statuses and what they mean? I know that a job status of zero means it completed successfully, but I would like to know what they other statuses are as well, since I have a job that appears to have run successfully, yet I get statuses other than zero for this job.

Thanks for your help!

Lola

Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Hi Lola,

Its in the manual as well! For 4.0, in the Server Job Developers guide, "Basic Programming" section, in the description for "DSGetJobInfo". The information is remarkably similar to that found in the source code.

Regards

- Chris Thornton

=================================================================
Chris Thornton
Ascential Software, mailto:Chris.Thornton@Informix.com
Davy Avenue, http://www.mk.ardentsoftware.co.uk
Knowlhill, http://www.AscentialSoftware.com
Milton Keynes,
Bucks. MK5 8HJ. U.K.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Thank you!

Lola

-----Original Message-----
From: Chris Thornton [mailto:Chris.Thornton@Informix.com]
Sent: Friday, June 08, 2001 9:53 AM
To: informix-datastage@oliver.com
Subject: RE: List of Job Statuses?



Hi Lola,

Its in the manual as well! For 4.0, in the Server Job Developers guide, "Basic Programming" section, in the description for "DSGetJobInfo". The information is remarkably similar to that found in the source code.

Regards

- Chris Thornton

=================================================================
Chris Thornton
Ascential Software, mailto:Chris.Thornton@Informix.com
Davy Avenue, http://www.mk.ardentsoftware.co.uk
Knowlhill, http://www.AscentialSoftware.com
Milton Keynes,
Bucks. MK5 8HJ. U.K.
Locked