Job status codes

[DSRajesh]

Hi

Can i know the status codes of datastage jobs?

[AmeyJoshi14]

Can you please elobrate it.
One of the method is you can use 'dsjob' command to view the Status code,where in you will get the Job status
for example:

dsjob -report Project_name Job_name(TESTING1) BASIC
Output:

Code: Select all

**************************************************
STATUS REPORT FOR JOB: TESTING1
Generated: 2008-05-05 11:28:36
   Job start time=2008-04-18 12:43:28
   Job end time=2008-04-18 12:43:44
   Job elapsed time=00:00:16
   Job status=2 (Finished with warnings)
Status code = 0 

[krisna]

We can USE 'dsjob' command at unix prompt to veiw the status code and other information of the job.

dsjob -report <project> <job|jobid> [DETAIL | FATAL]
dsjob -jobinfo <project> <job|jobid>

some of the job status codes follows like this.

DSJS.RUNNING = 0 --> This is the only status that means the job is actually running

DSJS.RUNOK = 1 --> Job finished a normal run with no warnings

DSJS.RUNWARN = 2 --> Job finished a normal run with warnings

DSJS.RUNFAILED = 3 --> Job finished a normal run with a fatal error

DSJS.VALOK = 11 --> Job finished a validation run with no warnings

DSJS.VALWARN = 12 --> Job finished a validation run with warnings

DSJS.VALFAILED = 13 --> Job failed a validation run

DSJS.RESET = 21 --> Job finished a reset run

DSJS.CRASHED = 96 --> Job has crashed

DSJS.STOPPED = 97 --> Job was stopped by operator intervention (can't tell run type)

DSJS.NOTRUNNABLE = 98 --> Job has not been compiled

DSJS.NOTRUNNING = 99 --> Any other status

[ray.wurlod]

That list is, in fact, ALL the job status codes. The mnemonics (constants) are defined in the header file JOBCONTROL.H in the DSINCLUDE directory.