Topic
2 replies Latest Post - ‏2012-10-05T18:28:25Z by Michael@Wellmark
lsant
lsant
3 Posts
ACCEPTED ANSWER

Pinned topic metadata table names

‏2012-09-27T05:28:39Z |
Hi

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.

Thanks
Updated on 2012-10-05T18:28:25Z at 2012-10-05T18:28:25Z by Michael@Wellmark
  • lsant
    lsant
    3 Posts
    ACCEPTED ANSWER

    Re: metadata table names

    ‏2012-10-01T12:29:00Z  in response to lsant
    Is there any option to enable Oracle session tracing from DS - We can find out the metadata table it writes to when a job is run.
  • Michael@Wellmark
    Michael@Wellmark
    1 Post
    ACCEPTED ANSWER

    Re: metadata table names

    ‏2012-10-05T18:28:25Z  in response to lsant
    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.