Sequence

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Sequence

Post by cherry »

Hi All,

I have a sequence that calls 23 jobs in one seqquence. I need to design, if one of the job aborts after running 18 jobs and 19th job gets aborted then I need to start run the sequence from 19th job only not from the first one. Could some one help how can we desighn this way.

Best Regards
Cherry
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Have you looked into "restartability" in Job Sequences yet, that would seem to be what you are looking for.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Exactly, it's all right there. At the very least enable the 'Add checkpoints' option and possibly the 'Automatically handle' one as well, depending on how explicitly you want to code your triggers.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Thanks All for the suggestions. I shall check and let you Know.


Regards
Ravi Kumar R Chennupalli
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Hi

In the sequence job properties I had checked the option "Add check points so sequence is restartable on failure". In the Individual sequence I had used execution action mode to "Reset if required then run". But then when I ran the sequnce it is executing form the first job. I guess iam missing some where. Could you please help me.

Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The Sequence job must abort (so the status says "Aborted/Restartable") for this to work. Which is what the "Automatically handle" option does for you - or you need to ensure it happens, with something like the Terminator stage, for instance.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Hi

I had given wrong parameters for a particular job to abort the sequence. The job activity got aborted and Later I had given the correct parameters to check the restartability, even then the sequence is starting from the first job activity. Pplease let me know.

Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Reread what I posted. The Sequence job itself must abort when any Job Activity aborts for this to work. Did that happen? Did the Sequence show as "Aborted/Restartable"?
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Yes Chullet, The Master sequence is in aborted state


Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

[sigh] "Aborted" or "Aborted/Restartable"? They are not the same.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Status shows as Aborted/Restartable. Sorry for that
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK... so when "restartable" it will automatically restart from the failed job when you run it again - unless you reset the Sequence first or have enabled the 'do not checkpoint' option.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Hi Chullet,

You mean to say, I need to check the "Do not Check Point" Also

Please confirm me.

Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No. "Do not checkpoint" means you want the activity to always run regardless of the checkpoint status. It was mentioned as a Thing To Not Do.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Post by cherry »

Thanks Chullet, Let me try and get back to you. Thanks for your patience in Helping my things done.

Regards
Cherry
Post Reply