Job Sequencing in Data Stage

Job Sequencing

It is Controlling the order of execution.

Master Job

Can run multiple jobs with the same name

Trigger 

Checking the compilation of job 1,  if it is compiled without errors, then job 2 is compiled.

Error handling 

This situation arises when Job is Aborted

Notification

When everything is successful, we should get a confirmation mail that it is Successful.

Wait for file 

Waits for the file, until it is searched and gets loaded into the source.

Checkpoints

If a job is aborted in between by any chance, check point make sure that the job starts from the point where it has failed.

Parameter Mapping 

We cannot use a parameter defined in 1 job to another job, TO do this we use parameter Mapping.

Job sequencing Stages are categorized into 4 groups 

1. Run stages
2. Flow control stages
3. Error handling stages
4. Other stages

New Select Sequence jobclick on view  click on palette option palette opens

Designing a Master Job 

To run a set of jobs in specific sequence   click view   Repository Select Jobs  Drag and Drop Required jobs.

Drag  the Job Activity  from the palette Right click  Browse the job 

Job Activity

Supports multiple outputs but only 1 i/p

Trigger

Sequencer

Multiple  inputs and multiple outputs

here we are executing Trigger Stage that is job finished with no errors/ Warnings.

Error handling

If job  aborts, we use Terminator

Master page

Interested in mastering DataStage Training?
Enroll now for a FREE demo on DataStage Training.

Exception handling Notification Activity Terminator

If Server is failed Exception handling

Job properties

Automatically handle Activities that fail If this is enabled, then only exceptions will perform and continues the job

Notification Activity 

Job finishes – mail has to be delivered

Aborts – mail

Server down – mail

Wait for file Activity

Properties browse the record file wait for file to appear do not timeout

Check points

Job properties

Add checkpoints to sequence is restartable on failure

Click on Job Activity

We can see the option Do not check point run

Parameter Mapping

Jobs  Insert parameter  Job properties  Add parameters

Oracle                      oracle parameter                parameter set

D no                                  deptn                               Integer

For in-depth understanding of DataStage click on

• Introduction to DataStage
• Architecture of Data Stage
• Oracle Enterprise in Data Stage
• SCD(Slow changing Dimension) in Data Stage
• DataStage Tutorials