Absolutely - those trigger expression need to be on the triggers from the Execute Command stage to each Job Activity stage, the triggers from there to the Sequencer should all be "OK" triggers.
Double-check the log entry for the Execute Command stage, post the contents of that log entry so we can see what value(s) it returned.
Craig, I have made the above said changes in my job design.
Execute command stage Log entries
SeqActJobs..JobControl (@EXC_Read_Seq_AcCode): Executed: sh -c /ajserver/inputs/docs_in/cat LKP_ACTCODE
Reply=127
Output from command ====>
LKP_ACTCODE: /ajserver/inputs/docs_in/cat: not found
SeqActJobs..JobControl (@EXC_Read_Seq_AcCode): Command sh -c did not finish OK, reply = '127'
SeqActJobs -> (SavingsAccount): Job run requested
Mode (row/warn limits) = 0/0
Job Parameters --->
$DBUserId=$PROJDEF
$DBPwd=$PROJDEF
$DBSchema=$PROJDEF
$DB=$PROJDEF
Cust_Id=10000
DSJobController=SeqActJobs
SeqActJobs..JobControl (DSRunJob): Waiting for job SavingsAccount to start
SeqActJobs..JobControl (DSWaitForJob): Waiting for job SavingsAccount to finish
SeqActJobs..JobControl (DSWaitForJob): Job SavingsAccount has finished, status = 1 (Finished OK)
SeqActJobs..JobControl (@SavingsAccount): Checkpointed run of job 'SavingsAccount'
SeqActJobs..JobControl (@Coordinator): Removed checkpoint record at successful completion of sequence
SeqActJobs..JobControl (@Coordinator): Summary of sequence run
10:19:40: Sequence started (checkpointing on)
10:19:40: EXC_Read_Seq_AcCode (COMMAND sh -c) started
10:19:40: EXC_Read_Seq_AcCode finished, reply=127
10:19:40: SavingsAccount (JOB SavingsAccount) started
10:19:43: SavingsAccount (JOB SavingsAccount) finished, status=1 [Finished OK]
10:19:43: Sequence finished OK
Finished Job SeqActJobs.
where
The sequence name : SeqActJobs
Name of the Sequential file containing account codes: LKP_ACTCODE
One of the job name that is included in sequence : SavingsAccount
Name of the Execute command stage : EXC_Read_Seq_AcCode
Now only one job in the sequence is running. Other jobs included in the sequence are found to be ignored.
In the sequence-->Job properties-->parameters I have used the parameters
$Path String $PROJDEF
catFname String cat LKP_ACTCODE(Default value)
Cust_Id Integer
In Execute command stage properties I have used
command: sh -c
Parameters: #$Path#/#catFname#
Kindly could you please look into this and advise.
Many Thanks