DSJE_DSJOB_ERROR
Moderators: chulett, rschirm, roy
DSJE_DSJOB_ERROR
I am trying to execute a job using Execute Command Activity inside the Sequence.
When i don't specify any parameters, the job executes fine.
When i specify the parameters, Sequence aborts does not execute the job.
It looks like some syntax error, but not sure where the error is:
**************************************
jsTestSeq.JobControl (@Execute_DataStageLog): Executed:dsjob -run -mode NORMAL -param paramRecLmt = 10 DEV TestdsjobExecute
Reply=255
Output from command ====>
Invalid arguments: dsjob -run
[-mode <NORMAL | RESET | VALIDATE>]
[-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
****************************
Inside the Execute Command Activity
On the command , i am specifying the following:
dsjob -run -mode NORMAL
On the Parameters, i am specifying the following:
-param paramRecLmt = 10 DEV TestdsjobExecute
Thanks in Advance.
When i don't specify any parameters, the job executes fine.
When i specify the parameters, Sequence aborts does not execute the job.
It looks like some syntax error, but not sure where the error is:
**************************************
jsTestSeq.JobControl (@Execute_DataStageLog): Executed:dsjob -run -mode NORMAL -param paramRecLmt = 10 DEV TestdsjobExecute
Reply=255
Output from command ====>
Invalid arguments: dsjob -run
[-mode <NORMAL | RESET | VALIDATE>]
[-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
****************************
Inside the Execute Command Activity
On the command , i am specifying the following:
dsjob -run -mode NORMAL
On the Parameters, i am specifying the following:
-param paramRecLmt = 10 DEV TestdsjobExecute
Thanks in Advance.
What happens if you enter the command as "dsjob" and parameters as "-run -mode NORMAL -param paramRecLmt = 10 DEV TestdsjobExecute
"
"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hmmm... ok. How "dynamic" are we talking about? If the number of different jobs are a small number, consider just branching to multiple Job Activity stages using triggers or the Nested Conditon stage.
If you are going to stick with the dsjob solution, make sure you include one of the WAIT options, probably "-jobstatus".
If you are going to stick with the dsjob solution, make sure you include one of the WAIT options, probably "-jobstatus".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Chulett,chulett wrote:Hmmm... ok. How "dynamic" are we talking about? If the number of different jobs are a small number, consider just branching to multiple Job Activity stages using triggers or the Nested Conditon stage. ...
The no of jobs are very high, that's the reason i am trying this method.
Hi Chulett,chulett wrote:Cool. Make sure you include one of the "wait" options with dsjob so that you know if it runs ok or not. ...
Now i am running into a different problem.
jsTestSeq.JobControl (@Execute_DataStageLog): Command dsjob -run did not finish OK, reply = '2'
Since my actual job is finishing with warnings, once the job is completed, my sequence is throwing exception, since ExecuteCommand Stage did not finish OK.
Even though i specified the trigger as Unconditional on ExecuteCommand stage, the next job is not getting triggered, it simply goes to exception.
Thanks in Advance.