To run a job from Command line

jaksani · Post by **jaksani** » Tue Mar 22, 2011 6:56 am

Hi,

I am new to this tool.
I have created a job with a parameter set file, consists of almost ten parameters.
I want to run that job from command line just by giving parameter set file name instead of giving each param.
Please let me know how to do this.

Thanks in Advance!

Regards,
Venkat Jaksani

jwiles · Post by **jwiles** » Tue Mar 22, 2011 11:44 am

Make the name of the Parameter set to be one of your job properties, then pass that on the command line as part of the -param option.

Execute $DSHOME/bin/dsjob -run on the command line to see the options for running the job if you're not familiar with all of them.

Regards,

ray.wurlod · Post by **ray.wurlod** » Tue Mar 22, 2011 1:16 pm

To specify a values file use

Code: Select all

-param paramsetname=valuesfilename

jaksani · Post by **jaksani** » Wed Mar 23, 2011 2:31 am

Hi,

I could not find 'Paramsetname' option in the below

dsjob -run
[-mode <NORMAL | RESET | VALIDATE>]
[-paramfile <filename>]
[-param <name>=<value>]
[-warn <n>]
[-rows <n>]
[-wait]
[-opmetadata <TRUE | FALSE>]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-local]
[-useid]
<project> <job|jobid>

I have tried below command

dsjob -run -paramfile NameTest -param ValueFilename=Test <consists of param values> OD_PROJECTS_DEV1<Project Name> nametestjob_uivj0<Job Name>

But it is not worked.

Please let me know the corrections to be made to above command.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 23, 2011 3:20 am

The -param and -paramfile options are mutually incompatible.

Read the DataStage Programmer's Guide, the section on Command Line Interface.

jaksani · Post by **jaksani** » Thu Mar 24, 2011 12:40 am

Thanks!

I did not find Programmer's guide.I will get it anyway.

For now,please let me know the command to run the job uses set of things mentioned below.

ParameterSet name : NameTest
Value File : Test
Jobname:Nametest
Project: Training

ray.wurlod · Post by **ray.wurlod** » Thu Mar 24, 2011 12:56 am

Code: Select all

dsjob [ login_clause ] -run -param NameTest=Test -jobstatus Training Nametest

jaksani · Post by **jaksani** » Thu Mar 24, 2011 2:40 am

I have given below command

./dsjob -run -param NameTest=Test -jobstatus OD_PROJECTS_DEV1<Project Name> nametestjob_uivj0<job name>

It is throwing below error message.

Error -3 getting information for parameter 'NameTest'

Status code = -3 DSJE_BADPARAM

Please help me.

chulett · Post by **chulett** » Thu Mar 24, 2011 6:43 am

What do you think 'bad param' might mean? The job does not have a parameter with that exact name, spelling and case.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 24, 2011 1:26 pm

Verify that parameter set NameTest has a values file called Test.

jaksani · Post by **jaksani** » Fri Mar 25, 2011 12:54 am

I have corrected it and ran it successfully.
Thanks for your valuable inputs.

Please let me know where can I get the list of Status Codes and its meaning?
Ex: Status Code=2 or 0 etc.
0 -> for success ful
2 -> ?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 25, 2011 1:10 am

Header file dsapi.h or JOBCONTROL.H (which you will find on the server) contains this information. Incidentally, 0 is not "successful". 0 is "running".