Viewing Scheduled Jobs in DataStage

Schedule

A job which is not compiled can’t be Schedule

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

To see Scheduled jobs

• Click on the Schedule symbol
• We can Schedule Multiple jobs at some time
• We can Reschedule, unschedule 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 finished  (see log) finished with warnings

Warning

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

Message Handling

To eliminate Warnings  in logs job Right-click   Add rule to messages Handle Add rule

Monitor

Tools  New Monitor Monitoring the job at stage level

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

 

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

Inclined to build a profession as Datastage Developer? Then here is the blog post on, explore Datastage Training

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

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

Unlock Jobs

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

Job name                        status

Peek 1                              Running  while in running condition  

Click on STOP (or) Unlock the jobs

Director

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

Clean up resources

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

Release all (or) In Command line

$  PS to list p id‘s

$ Kill cmd  to unlock Jobs

EX: $ kill peek 1

How to run a Job through the command line?

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

If parameters are not there

DS job –run – project name – job name

For an 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