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 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
- 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
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 Right click Add rule to message 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 an 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
Desired to gain proficiency on DataStage?Explore the blog post on DataStage training to become a pro in DataStage.
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 an 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
- 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 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