DSXchange

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.

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.

Don't re-invent the wheel. Download ETLstats from Kim Duke's web site. It will do all that work for you, and more.