Exec job from command line

Juls · Post by **Juls** » Mon Apr 14, 2008 10:04 am

Hi,
I read all the posts on this but still seem to be having problem
I am running the following code in my batch file but get an error:

project = ENT_DWH
job=seq_STAGING

e:\Ascential\DataStage\Engine\bin\dsjob -run NORMAL -wait ENT_DWH seq_STAGING -param '$envLoadDateTime=2008-04-14 12:00:00'

Invalid arguments: dsjob -run
[-mode <NORMAL | RESET
[-param <name>=<value>
[-warn <n>]
[-rows <n>]
[-wait]
[-opmetadata <TRUE | F
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-useid]
<project> <job|jobid>

Status code = -9999 DSJE_DSJOB_ERROR

chulett · Post by **chulett** » Mon Apr 14, 2008 10:08 am

Does it work if you pass in full credentials - server, username and password? Or just the server?

Juls · Post by **Juls** » Mon Apr 14, 2008 10:18 am

chulett wrote:Does it work if you pass in full credentials - server, username and password? Or just the server? ...

It doesn't work when I add server. When you say user name and password? Which are those? I am an admin on the box.. shouldn't it run under my credentials?

chulett · Post by **chulett** » Mon Apr 14, 2008 10:45 am

It "should" but doesn't always work without it. try with whatever user/pwd you would use with the client.

Juls · Post by **Juls** » Mon Apr 14, 2008 11:41 am

chulett wrote:It "should" but doesn't always work without it. try with whatever user/pwd you would use with the client. ...

Added username and password but still doesn't work. See below:

E:\>e:\Ascential\DataStage\Engine\bin\dsjob -run NORMAL -wait -server FTLDETL01
-user juls -password s1203 ENTERPRISE_DATA_WH seq_STAGING_VANTIVE -param '$
envLoadDateTime=2008-04-14 12:00:00'
Invalid arguments: dsjob -run
[-mode <NORMAL | RESET | VALIDATE>]
[-param <name>=<value>]
[-warn <n>]
[-rows <n>]
[-wait]
[-opmetadata <TRUE | FALSE>]
[-disableprjhandler]
[-disablejobhandler]
[-jobstatus]
[-userstatus]
[-useid]
<project> <job|jobid>

Status code = -9999 DSJE_DSJOB_ERROR

E:\>pause
Press any key to continue . . .

chulett · Post by **chulett** » Mon Apr 14, 2008 12:26 pm

Server name and userid/password need to come first, right after the dsjob command - then all of the other stuff.

Juls · Post by **Juls** » Mon Apr 14, 2008 12:40 pm

I changed it but still same error

kcbland · Post by **kcbland** » Mon Apr 14, 2008 1:22 pm

Take that NORMAL keyword out or qualify it properly with the command line token -mode.

Juls · Post by **Juls** » Mon Apr 14, 2008 1:37 pm

Actually I just got it to work .. .Now I need to enhance this line to add -param values. However I have environment variables as parameters. What would the syntax be for this:
variable: $envLoadDateTime
value: 2008-04-14 12:00:00

would I put $envLoadDateTime=2008-04-14 12:00:00 in quotes?
"$envLoadDateTime=2008-04-14 12:00:00" or just value in single ticks, because it has spaces?