DSXchange

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!!

It seems to be Job activity 1 has completed with warnings.

Check the trigger condition of Job Activity1. Whether it has handled for "Executed OK" and "Execution finished with warnings"

What are the triggers on the first job activity?

Do you have any warnings in the log for the first job?

Regards,

Thanks Ravi and jwiles.

There were some warnings in the JobActivity1. I have changed the trigger condition to "Execution finished with warnings".

But is it advisable to use this trigger condition??

Thanks.

Only if you know it will always end with warnings, now a clean run without warnings will not trigger the following step. Perhaps both conditions should be used?