Group Discounts available for 3+ students and Corporate Clients

Job Sequencing in Data Stage

Job Sequencing

It is Controlling the order of execution.

Master Job

Can run multiple jobs with the same name

Screenshot_93

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 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 a 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 timeout

Check points

Job properties

Add checkpoints to sequence is restartable 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 in-depth understanding of DataStage click on

“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 *

    Support


    Please Enter Your Details and Query.
    Three + 6