Compilation of Job 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

Post Reply
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Compilation of Job Sequence

Post by Nagin »

I have a Master Jobsequence 'A' calling multiple job sequences jobsequence1, job sequence2, job sequence3... and so on. If I modify a job in the job sequence1 and compile the job but not the jobsequence1, would it cause any trouble when I kick off the Master Jobsequence? In other words what happens if I dont compile the job sequence when an underlying job is modified and compiled? will the changes that have been made be in effect?
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

It is not needed that you have to recompile the job sequence, if you make changes to the underlying job. As long as the job name in the Job activity remains the same and is compiled, you are safe.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

... and the job parameters remain unchanged. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Post by Nagin »

Thanks Narasimha and Craig, that answers my question. And would it be OK to assume that it is the same thing when we reset the Job Sequence status?. For instance, If the underlying job aborts for some reason, the sequence will also abort. In this situation, if I just modify the job, recompile it and reset the status of the Job sequence it should be running fine with taking the new changes in effect, right?
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

In the Job Activity's "Execution action select "Reset if required, then run"
Now you don't need to go to the underlying job and reset it there.
The job will automatically get reset and run the next time you run the sequence.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Nagin wrote:And would it be OK to assume that it is the same thing when we reset the Job Sequence status?. For instance, If the underlying job aborts for some reason, the sequence will also abort. In this situation, if I just modify the job, recompile it and reset the status of the Job sequence it should be running fine with taking the new changes in effect, right?
Yes. Making changes to or recompiling a job (with the restrictions noted above) won't adversely affect the ability of the Sequence job that controls it to handle it just fine. However...

Keep something in mind - if you have a restartable Sequence job, one that is in an 'Aborted/Restartable' status, then if you Reset it will start over from the beginning. You must leave the status alone and simply run it for it to pick up from the most recent checkpoint.

And the 'Reset if required' option *is* smart enough to not reset an Aborted/Restartable child Sequence job. :wink:
-craig

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