Skip Jobs in Sequencer

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Skip Jobs in Sequencer

Post by karthi_gana »

All,

my sequencer job is used to call the parallel jobs based on the previous jobs status. i.e. RUNOK or RUNWARNING.

JobActivity1 --> JobActivity2--> JobActivity3 --> JobActivity4 --->
JobActivity5 -->JobActivity6

is it possible to skip any job from the sequencer? say for example,

i don't want to run JobActivity4 when i run the sequencer.

I used Custom Condition and DSJS.RUNOK OR DSJS.RUNWARNING.

So I think it is not possible.

we can skip the jobs which ran successfully in the first run. i.e. if the sequencer failed and restarted again,
the job which ran successfully can be skipped by choosing an option under "compilation". Am i correct?
Karthik
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No, you cannot skip tasks unless (as you mentioned) you have enabled checkpoints, you are restarting and those tasks were successful - and then it's automatic. Would be nice if you could simply 'Disable' a task or execute individual tasks ala Informatica but sadly one cannot.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

We are working with a consulting team. They create a file for each job. If the file exists then they skip that job. So it would easy to skip jobs or run a job. The end of the main sequence deletes all these temp files. Works really well. Easy to implement too.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Interesting idea. Thought about something similar back in the day but never had any time to do anything of the sort. Could be fun. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

If I get time then maybe I can export an example job. Let me see if the consulting firm minds. Let you know.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could also use the "UniVerse" numbered public semaphores for this.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply