Hi All,
I want know the log information for datastage jobs like HOW MANY RECORDS PROCESSED IN THE LAST RUN OF THE JOB,HOW MANY RECORDS ARE REJECTED,AND LAST JOB RUN STATUS,ETC....
Please provide the sql scripts any body for getting the above information.
DataStage jobs Log information
Moderators: chulett, rschirm, roy
There are well established and documented APIs for getting job and log information. Check your online help's Index for functions that start with "DSGetLog___" and you'll find several for getting log information. You can also get generic information about a job, such as its last status, with those functions listed as "DSGetJob___" functions.
There are command line equivalents for all of them if you prefer a scripted approach. The dsjob command line job launcher can also be used to get job status and full log information.
There are command line equivalents for all of them if you prefer a scripted approach. The dsjob command line job launcher can also be used to get job status and full log information.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Don't re-invent the wheel. Download ETLstats from Kim Duke's web site. It will do all that work for you, and more.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.