• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Job Sequencing in Data Stage

Job Sequencing

It is Controlling the order of execution.

Master Job

Can run multiple jobs with same name

Screenshot_93

Trigger 

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

Error handing 

This situation arises when Job is Aborted

Notification

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

Wait for file 

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

check points

If 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 in to 4 groups 

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

 

New 11Select Sequence job11click on view  11click on palette option 11palette opens

Designing a Master Job 

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

 

Screenshot_94

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

Job Activity

Supports multiple outputs but only 1 i/p

Trigger

Screenshot_95

Sequencer

Multiple  inputs and multiple outputs

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

Error handling

If job  aborts , we use Terminator

Screenshot_96

Master page

111

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

Exception handling 11Notification Activity 11Terminator

If Server is failed 11Exception handling

Job properties

Automatically handle Activities that fail 11If 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 11browse the record file11 wait for file to appear   do not time out

Check points

Job properties

Add check points to sequence is restart able on failure

Click on Job Activity

We can see the option11 Do not check point run

Parameter Mapping

Jobs 11 Insert parameter 11 Job properties 11 Add parameters

Oracle                      oracle parameter                parameter set

D no                                  deptn                               Integer

For indepth understanding of DataStage click on

Summary
Review Date
Reviewed Item
Job Sequencing in Data Stage
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Job Sequencing in Data Stage"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.