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
- auto sys
- control M
- 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:-
- can control the order of execution of datastage jobs in no. of ways
- Batch Jobs
- JCL Scripting à job control language
- Job Sequencing
- M or Cron Tab
Inclined to build a profession as Datastage Developer? Then here is the blog post on, explore Datastage Training
Tools Batch
New
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