EXEPTION HANDLER and CHECKPOINTS on sequences

rpezzotti · Post by **rpezzotti** » Tue Mar 27, 2007 5:31 pm

Hello

I've already searched in this forum and didn't find anything that helped.
I have the following situation here:

JOB1 ------\
            \
JOB2 --------> SEQUENCER --------> JOB3
            /
JOB3 ------/

      EXEPTION_HANDLER --------> NOTIFICATION_ACTIVITY

I've checked the "Add checkpoint so sequence is restartable" option.
Then I've started this sequence and the Jobs 1, 2 and 3 began to run.
The "Job1" has finished OK and had his run checkpointed.
Then the "Job2" has aborted before the "Job3" finished and, after this, the exeption handler has started and sent me an e-mail
The problem is: the "Job3" was still runing and it finished OK, but did not had his run checkpointed.
When I restart this sequence, that has aborted, the "Job3" has been executed again.

Does anybody can help me?
Thank you

kduke · Post by **kduke** » Tue Mar 27, 2007 5:54 pm

It looks like it did what it was supposed to do. You told it not to worry about job3. So it will always rerun it.

chulett · Post by **chulett** » Tue Mar 27, 2007 6:16 pm

Besides the fact that you have two "JOB3" stages, the last one needs an OK trigger if you want it to be checkpointed properly

Code: Select all

JOB1 ------\
            \
JOB2 --------> SEQUENCER --------> JOB3 ----> SEQUENCER
            /
JOB3 ------/

      EXEPTION_HANDLER --------> NOTIFICATION_ACTIVITY

rpezzotti · Post by **rpezzotti** » Wed Mar 28, 2007 6:25 am

Sory....

my fault
there are only one JOB3 and its is not checked to "do not checkpoint"

Code: Select all

JOB1 ------\ 
            \ 
JOB2 --------> SEQUENCER --------> JOB4 
            / 
JOB3 ------/ 

      EXEPTION_HANDLER --------> NOTIFICATION_ACTIVITY

tks

chulett · Post by **chulett** » Wed Mar 28, 2007 7:35 am

Ok... Can you restate your problem, please? What does or doesn't happen or what is it that you are trying to accomplish that isn't quite working out.

rpezzotti · Post by **rpezzotti** » Wed Mar 28, 2007 8:14 am

chulett wrote:Ok... Can you restate your problem, please? What does or doesn't happen or what is it that you are trying to accomplish that isn't quite working out.

Into the diagram I've sent, you can see 3 jobs that starts simultaneous.
The JOB1 and the JOB3 has finishied both OK, but before the JOB3 has finished, the JOB2 has aborted.

This sequence is restartable. Then i just restarted it.

The JOB1 was skipped corectly, but, i don't know why, the JOB3 was not skipped.

This is my problem: Why the JOB3 was not checkpointed if it did finish OK?
The right action was rerun only the JOB2 ?

tks

DSXchange

EXEPTION HANDLER and CHECKPOINTS on sequences

EXEPTION HANDLER and CHECKPOINTS on sequences

Re: EXEPTION HANDLER and CHECKPOINTS on sequences