Page 1 of 1

dsjob -run error

Posted: Sun Oct 21, 2012 8:14 pm
by vishu19aug
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.

Posted: Sun Oct 21, 2012 8:23 pm
by chulett
[-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.

Posted: Sun Oct 21, 2012 8:25 pm
by vishu19aug
if i don't include -param .. get the same error :(

Posted: Sun Oct 21, 2012 11:23 pm
by ray.wurlod
Options -wait and -jobstatus are mutually exclusive, you can have one or the other or neither, not both.

Posted: Mon Oct 22, 2012 6:18 am
by chulett
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?

Posted: Mon Oct 22, 2012 6:37 am
by ray.wurlod
Try using a project name rather than a project pathname.

Posted: Mon Oct 22, 2012 6:48 am
by chulett
D'oh! Didn't notice that. :cry:

Posted: Mon Oct 22, 2012 8:58 am
by vishu19aug
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

Posted: Mon Oct 22, 2012 9:04 am
by chulett
Now you need to add the credentials to access the project - userid, password, domain.

Posted: Mon Oct 22, 2012 9:19 am
by vishu19aug
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?

Posted: Mon Oct 22, 2012 10:09 am
by chulett
You need to provide the credentials of whichever userid you want the job to run under.