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

Viewing Scheduled Jobs in DataStage

Schedule

A job which is not compiled can’t be Schedule

Right click a job 11add to Schedule à Set the time

To see Scheduled jobs

  • Click on Schedule symbol
  • We can Schedule Multiple jobs at some time
  • We can Re schedule, un schedule the jobs

Real time

In Real time, Scheduling will not be done in Director

Some Tools

  1. auto sys
  2. control M
  3. Cron TAB – utility in UNIX

If a job is found in this way

Job 11finished  (see log) 11finished with warnings

Warning

Example:-  when binding input interface field “Dept no” to field “Dept no” converting a null able source result ;a fatal run time error could occur;  use a modify operator, so specify the  value to which the null should be converted.

Message Handling

To eliminate Warnings  in logs job 11Right click  11 Add rule to message Handle 11Add rule

Monitor 

Tools 11 New Monitor11 Monitoring the job at stage level

when we are loading with less  no. of records, Data set in not an good performance

 

Screenshot_81

Batch Jobs

Executing Set of jobs in Sequence

Note :-

  1. can control the order of execution of datastage jobs in no. of ways
  2. Batch Jobs
  3. JCL Scripting à job control language
  4. Job Sequencing
  5.  M or Cron Tab
Desired to gain proficiency on DataStage?
Explore the blog post on DataStage training to become a pro in  DataStage.

Tools 11Batch11New 11Save as new Batch  11 Browse and select 1 job 11 Add job 11 we can see JCL Scripting 11Select 1 MCL Job 11 Add

  • 2 Jobs are running in an sequence
  • Batch successfully compiled with no errors

11Unlock Jobs

Q:   How to about / terminate a Job while it is Running ?

 

Job name                        status

Peek 1                              Running 11 while in running condition

 

Click on STOP   (or) Unlock the jobs

Director

  • Clean up resources
  • Developer will Access the director
  • Clean up resources to get enabled in director
  • Administrator àprojects à enable job admin in director

Clean up resources

Job 11 Clean up resources 11 PID 11 process In ’s  show all 11Select

Release all (or) In Command line

$  PS 11to list p id ‘ s

$ Kill cmd 11 to unlock Jobs

EX:- $ kill peek 1

How to run a Job through command line ?

DS Job – run – project name- job name-parameter

If parameters are not there

DS job –run – project name – job name

For indepth understanding of DataStage click on

Summary
Review Date
Reviewed Item
Viewing Scheduled Jobs in DataStage
Author Rating
4

“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 Viewing Scheduled Jobs in DataStage"

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.