Sequence not running the job Activity

[dsadm_ws]

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

[Ravi.K]

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"

[jwiles]

What are the triggers on the first job activity?

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

Regards,

[dsadm_ws]

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.

[chulett]

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?