Blog
Viewing Scheduled Jobs in DataStage
10 October, 2020
Related Blogs
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 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