How to submit a Datastage Job from UNIX command line

trammohan · Post by **trammohan** » Mon Feb 23, 2004 10:35 am

Hi ,

How to submit a Datastage job ( Datastage 7.0 ) from UNIX command line?

Thanks
Ram

kcbland · Post by **kcbland** » Mon Feb 23, 2004 10:37 am

This is covered fully on this site. Search for anything on dsjob, the unix command line interface.

Here is a script that I posted if you're looking for examples of a fully fleshed interface:

viewtopic.php?t=85578

roy · Post by **roy** » Mon Feb 23, 2004 11:17 am

Hi,
was curious...
for 1 since your talking enterpise edition (AKA paralel extender or PX) why not post it in the right place?
and 2ndly Ken, does this script covers all there is for the PX edition and PX jobs?
(for my 2nd observation, since I'm no PX expert I guess some else might answer that, I'm just asking the question myself.)

p.s.
I invite everyone to read Ray's advice on posting etc' in the last news-letter, it's right on the money IMHO(even opened my eyes to the add to favorites option

)

kcbland · Post by **kcbland** » Mon Feb 23, 2004 3:51 pm

roy wrote: and 2ndly Ken, does this script covers all there is for the PX edition and PX jobs?

As far as I know, dsjob works for all job types. Since this script just executes dsjob and uses it to query for job status, I hope there's no problems. All of the other stuff is used to simply demonstrate gathering parameter values, passing them in, prep'ing some audit tables, etc. All of the good stuff that makes the jobstream flexible and give an audit trail.

holgi02 · Post by **holgi02** » Mon Feb 23, 2004 6:12 pm

On a related subject - is there a definitive list in the documentation of the exit codes and meanings from dsjob? I have looked but failed to find them anywhere.

Tx.

Gil.

chulett · Post by **chulett** » Mon Feb 23, 2004 6:18 pm

Yep! Should be under your 'DSEngine/include' directory in the dsapi.h header file. Or at least it is for a UNIX server of Version 7.x vintage. One of the perils of coming in at the end of a thread like this - we don't know your specs, just the original poster's.

holgi02 · Post by **holgi02** » Mon Feb 23, 2004 6:44 pm

I never thought to look in the header files - silly me

Perhaps those good people at Ascential could get it into a .pdf manual somewhere.

Thanks chaps.

Gil.

holgi02 · Post by **holgi02** » Wed Feb 25, 2004 7:05 am

Further information about job exit status codes and meanings found as follows on a Windows install taking ALL the defaults at
C:\Ascential\DataStage\Dsdk\include\dsapi.h

Code: Select all

/* 'jobStatus' values... */

#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 (can't tell run type) */
#define DSJS_NOTRUNNABLE 	  98	/* Job has not been compiled */
#define DSJS_NOTRUNNING	    99	/* Any other status */

This would appear to be the list I was looking for.

Thanks,

Gil.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 25, 2004 2:44 pm

The same list, for BASIC, is in dsinclude/JOBCONTROL.H in your project directory. The constants are set up using EQUATE (rather than #define, which is for C).
To use these in your routines, include the following declarations in the top of your source code.

Code: Select all

$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF