Conditional Job Start from Routine Value

shrey3a · Post by **shrey3a** » Wed Sep 21, 2005 3:58 pm

Hi,

I need to start or abort the job based on the return value of the routine.

Scenario

I've a routine which I'm planning to call in sequencer thro' routine stage the routine returns the value 1 and 0 , I need to start the Datastage job if the value is 1 and do not start the job if value is 0.

Regards,

chulett · Post by **chulett** » Wed Sep 21, 2005 4:09 pm

Simple enough with a Nested Condition stage. Have it check the return status and either go down a link that runs your job or a second link that bypasses it. Both should end at a Sequencer stage set to 'Any' if the job stream needs to continue.

shrey3a · Post by **shrey3a** » Wed Sep 21, 2005 4:29 pm

Hi Craig,

How to check the return status of routine in Nested condition stage.
It do not give the option to do it.

The scenario is If the routine returns the value 44 the run the job else do not run the job.

Regards

chulett wrote:Simple enough with a Nested Condition stage. Have it check the return status and either go down a link that runs your job or a second link that bypasses it. Both should end at a Sequencer stage set to 'Any' if the job stream needs to continue.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 21, 2005 4:54 pm

It's an "activity variable" in your job sequence.
RoutineActivityName.$ReturnValue

chulett · Post by **chulett** » Wed Sep 21, 2005 5:19 pm

Yup, just like that.

And make sure you understand that RoutineActivityName in Ray's example is the name of the preceeding Routine Activity stage itself, not the routine it is calling.