We are using Datastage version 8.5 and I would like to get the following information from the metadata tables.
1) Job start time and end time
2) Job status (Success / Failure )
3) Row applied / Rows rejected.
Can you give me the metadata table names , column names which will store the above information.
Michael@Wellmark 2700002T591 Post
Re: metadata table names2012-10-05T18:28:25ZThis is the accepted answer. This is the accepted answer.I'm also looking for the Universe table and column names for the last run date/time, programmatically in UNIX. I can get this via dsjob -jobinf, but for 1900 jobs this takes 20 minutes.