Hi,
I have around 30 Value Files in my Parameter Set. I want to run my job for the values present in 30 Value Files.
I have made my job as Multiple Instance job and I have created a sequencer with 30 JOB ACTIVITY which is calling this job with different Invocation Id and Value file.
Is there any way to achieve this using looping in sequencers so that I can pass different value file from parameter set each time using only one job activity?
Let me know in case of any doubts in question.
Thanks
Running single job for all value file set
Moderators: chulett, rschirm, roy
Yes Craig. I created delimited list of values as below:
1|A
2|B
3|C
(There is no enter after C)
I am reading this file using Command Activity stage in sequencer using below Command:
paste -s -d ',' <File Name>
This will give below output:
1|A,2|B,3|C
After this I am using Loog start Activity having "List Loop" and 'Delimited Values' as #Execute_Command_95.$CommandOutput#
Delimiter is COMMA.
Then in Job Activity I am passing 1 and A from source to job using field function like below:
Field(StartLoop_Activity_96.$Counter,'|',1)
Field(StartLoop_Activity_96.$Counter,'|',2,1)
Now its working fine till Iteration 2, but during Interation 3 sequencer is getting aborted:
testseq.JobControl (@Job_Activity_97): Controller problem: Error calling DSSetParam(Table), code=-4
[ParamValue/Limitvalue is not appropriate]
It not able to pass "C" to job activity. Any idea on this.
1|A
2|B
3|C
(There is no enter after C)
I am reading this file using Command Activity stage in sequencer using below Command:
paste -s -d ',' <File Name>
This will give below output:
1|A,2|B,3|C
After this I am using Loog start Activity having "List Loop" and 'Delimited Values' as #Execute_Command_95.$CommandOutput#
Delimiter is COMMA.
Then in Job Activity I am passing 1 and A from source to job using field function like below:
Field(StartLoop_Activity_96.$Counter,'|',1)
Field(StartLoop_Activity_96.$Counter,'|',2,1)
Now its working fine till Iteration 2, but during Interation 3 sequencer is getting aborted:
testseq.JobControl (@Job_Activity_97): Controller problem: Error calling DSSetParam(Table), code=-4
[ParamValue/Limitvalue is not appropriate]
It not able to pass "C" to job activity. Any idea on this.
Atul
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks All,
It solved the issue.
After CAT the source file, execute below code in User Variable
Trim(Convert(@FM,',',MOVE_TO_SOURCE.$CommandOutput),',','T')
above will convert all new lines to comma and remove the last comma.
And then start the loop on list of values from user variable stage.
Thanks
It solved the issue.
After CAT the source file, execute below code in User Variable
Trim(Convert(@FM,',',MOVE_TO_SOURCE.$CommandOutput),',','T')
above will convert all new lines to comma and remove the last comma.
And then start the loop on list of values from user variable stage.
Thanks
Atul