Execution order of the jobs

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
New2DS
Participant
Posts: 33
Joined: Sat Jun 26, 2004 9:58 am

Execution order of the jobs

Post by New2DS »

Hi! All,

If you have 3 different jobs in one window which one will run first. Does all three jobs run parallel or will they run in the order they are.

For example: In one window one job creates a flat file with the header row and second job will append the detail to the headerfile and third will append the trailer to the same flatfile.

If they run in parallel, is there anyway that we can make them to work one after the other instead of creating 3 new jobs.

thanks,
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: Execution order of the jobs

Post by ogmios »

There's no defined order.

You have to make a schedule job (either in BASIC or as a sequencer) to run the jobs in sequence. And then start this job which will control the execution of the other jobs

Alternatively you can start the jobs up in order via dsjob in a UNIX script.

All methods have been thoroughly discussed before.

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

Post by chulett »

Ok.. what do you mean by "three jobs in one window"? :?

If that means three Job Activity stages in a Sequencer job that are not linked together, then yes they will run in parallel.

To enforce an order, you need to link them together - in the proper order, of course. The 'triggers' between the jobs will allow you to check the completion status of one before moving on to the next.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply