DSXchange

Hi Friends

I am facing a issue with a sequencer. Sequencer design is as below

Routine Activity---> Job

Many a times the sequencer is making checkpointed run to routine. In this case it is not returning value to job and job is running with default parameter.

RC_SEQ_J_G4211..JobControl (@Routine_MapVar_Lookup): Checkpointed call of routine 'DSU.GetLastUpdDateTime'

I am not understanding why it is making checkpointed call to routine.

Also on very few occasion the sequencer is running correctly with the routine returning value

Appreciate your help

Check the "do not checkpoint run" property in the Routine activity to prevent it from being checkpointed (to force the routine to be run every time the sequence runs).

Thanks Ray. I will check

The point of confusion to me is why it is making checkpointed call on most occasions and a normal call at few times.

There is no abort in the sequencer in any case

Thanks for your help

What options do you have enabled in the Sequence job? Does the routine return something other than a zero for success or a non-zero value for failure?

If that's literally all you have in the Sequence and you disable checkpoints for the routine then there's absolutely no reason to have them enabled at all.