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
Exec job from command line
Moderators: chulett, rschirm, roy
Added username and password but still doesn't work. See below:chulett wrote:It "should" but doesn't always work without it. try with whatever user/pwd you would use with the client. ...
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 . . .
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?
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?