Hi,
I have designed a Sequence job, with the following design:
JobActivity1-->RoutineActivity-->JobActivity2
JobActivity1: gets the MaxKey value from a table and load it into a Txt file.
RoutineActivity: use a routine "GetFileName" with Parameters as:pathName and FileName
Triggers:
ExpressionType Expression
ReturnValue(conditional) <> ""
Otherwise
JobActivity2: Uses the returnValue as a parameter
pMaxKey: Routine_Activity_37.$ReturnValue
The issue with the above logic is the sequence only runs the JobActivity1 and finishes the job.
Its not reading the other 2 activities. Is my approch towards the design correct? If not can you advice any other alternative.
Thanks in Advance!!
Sequence not running the job Activity
Moderators: chulett, rschirm, roy
Re: Sequence not running the job Activity
What are the triggers on the first job activity?
Do you have any warnings in the log for the first job?
Regards,
Do you have any warnings in the log for the first job?
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.