Start Loop in DS7.1
Moderators: chulett, rschirm, roy
Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Three pages now, eh? Hope they can afford the bill when it comes due.pmadhavi wrote:I diasabled the mutli instance option long back. Only for the first value of the csv file, the job is running successfully. But for 2nd onwards, it is showing the following warning in the main job:
<jobname>..Transformer_0 (DSRunJob): Job control error (-2)
(DSRunJob) Job <sequencejob> is not in a runnable state
![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
Guessing here that with the multi-instance option 'disabled long back' the job is not in a runnable state because it is still running from the first value's launch.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Please find the below code in the routine which is calling the sequence job.DSguru2B wrote:Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.
$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle1 = DSAttachJob (<jobname>, DSJ.ERRWARN)
ParamName="Number"
ParamValue=Arg1
DsErrCode = DSSetParam(JobHandle1, ParamName, ParamValue)
ErrCode = DSRunJob(JobHandle1 , DSJ.RUNNORMAL)
Result = DSGetJobInfo (JobHandle1, DSJ.JOBSTATUS )
ErrCode1 = DSDetachJob(JobHandle1)
if DsErrCode=0 then Ans=Result
else Ans=Result
--------------------------------------
please find the log of the sequence below:
there's no warnings; its runnign fine and it is showing the log for the first value from the csv.
TestInvocation..JobControl (@Coordinator): Summary of sequence run
13:44:34: Sequence started
13:44:34: Job_Activity_0 (JOB <job1>) started
13:44:38: Job_Activity_0 finished, status=1 [Finished OK]
13:44:39: Job_Activity_1 (JOB <job2>) started
13:44:45: Job_Activity_1 finished, status=1 [Finished OK]
13:44:47: Job_Activity_5 (JOB <job3>) started
13:44:49: Job_Activity_5 finished, status=1 [Finished OK]
13:44:49: Sequence finished OK
(Mainjob) <- TestInvocation: Job under control finished.
-------------------------------------------
And i am using DSRunJob routine instead of Utilityjobrun.
Thanks,
Madhavi
Madhavi
Specifically, you can't check for status until it has completed. Well, you can but you won't get what you are thinking you are getting.
Which means your error *is* because it was still running, hence not in a 'runable' status...
Code: Select all
DsErrCode = DSSetParam(JobHandle1, ParamName, ParamValue)
ErrCode = DSRunJob(JobHandle1, DSJ.RUNNORMAL)
ErrCode = DSWaitForJob(JobHandle1)
Result = DSGetJobInfo(JobHandle1, DSJ.JOBSTATUS)
ErrCode1 = DSDetachJob(JobHandle1)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: