dsjob -run error

vishu19aug · Post by **vishu19aug** » Sun Oct 21, 2012 8:14 pm

Hi,

I am running the following from a datastage sequence (because i don't have access on dsadm) -

/opt/app/ibm/InformationServer/V87/Server/DSEngine/bin/dsjob -run -mode NORMAL -param -warn 0 -rows 0 -wait -jobstatus /opt/app/ivrr/shared/projects/xxx_dev1 JobNightly_SubSeq2

it fails with the following error -

Reply=255
Output from command ====>
Invalid arguments: dsjob -run
[-mode <NORMAL | RESET | RESTART | VALIDATE>]
[-paramfile <filename>]
[-param <name>=<value>]
[-warn <n>]
[-rows <n>]
[-wait]
[-opmetadata <TRUE | FALSE>]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-local]
[-useid]
<project> <job|jobid>

Status code = -9999 DSJE_DSJOB_ERROR
can somebody please help? what is wrong here? iam new to unix.

chulett · Post by **chulett** » Sun Oct 21, 2012 8:23 pm

[-param <name>=<value>]

Either pass a name/value pair or don't include the "-param" if you don't need to pass a parameter. Also, use either -wait or -jobstatus, not both.

vishu19aug · Post by **vishu19aug** » Sun Oct 21, 2012 8:25 pm

if i don't include -param .. get the same error

ray.wurlod · Post by **ray.wurlod** » Sun Oct 21, 2012 11:23 pm

Options -wait and -jobstatus are mutually exclusive, you can have one or the other or neither, not both.

chulett · Post by **chulett** » Mon Oct 22, 2012 6:18 am

But using both doesn't cause an error from what I recall, just confusion. Can you post the current version of your dsjob command and the latest error you are getting?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 22, 2012 6:37 am

Try using a project name rather than a project pathname.

chulett · Post by **chulett** » Mon Oct 22, 2012 6:48 am

D'oh! Didn't notice that.

vishu19aug · Post by **vishu19aug** » Mon Oct 22, 2012 8:58 am

I removed the path from the project name and run the following -
/opt/app/ibm/InformationServer/V87/Server/DSEngine/bin/dsjob -run -mode NORMAL -warn 0 -rows 0 xxx_dev1 JobNightly_Dynamic_Lookups

getting the following error -

Output from command ====>
ERROR: Failed to open project

chulett · Post by **chulett** » Mon Oct 22, 2012 9:04 am

Now you need to add the credentials to access the project - userid, password, domain.

vishu19aug · Post by **vishu19aug** » Mon Oct 22, 2012 9:19 am

If i run this from command line under dsadm .. do i still need to provide the credentials. I guess the credentials would be of dsadm?

chulett · Post by **chulett** » Mon Oct 22, 2012 10:09 am

You need to provide the credentials of whichever userid you want the job to run under.