how do we know when a job was compiled

Mercury · Post by **Mercury** » Tue Jun 29, 2010 12:54 am

Hi, Is there a way to find the date/time of compilation of a job?

Thanks

udayk_2007 · Post by **udayk_2007** » Tue Jun 29, 2010 1:07 am

you can usually see this information in DataStage Director

Regards
Ulhas

Mercury · Post by **Mercury** » Tue Jun 29, 2010 1:19 am

udayk_2007 wrote:you can usually see this information in DataStage Director

Hmmm..true
But there's a limit to the number of messages retained in the log, so I don't find this info in the log..

Also, is there a way to know the date/time when a job was last modified?

Thanks

ArndW · Post by **ArndW** » Tue Jun 29, 2010 1:25 am

While the DS_AUDIT hashed file contains information on the modification dates and times it doesn't store the compile time, in order to find that when the director log has been purged one would need to look into the appropriate RT_STATUS file - but the file structures for both DS_AUDIT and RT_STATUSnnn are not documented and are not readily accessible for the average DataStage user so it is not a simple answer.

kduke · Post by **kduke** » Tue Jun 29, 2010 10:56 am

Manager stores last modification time. Not sure if this gets updated after a compile.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 29, 2010 2:40 pm

A very wild guess - can we say that the last modification time of RT_CONFIGnnn will be the last compilation time ?

I am off-site and do not have DataStage to check.