Page 1 of 1

how do we know when a job was compiled

Posted: Tue Jun 29, 2010 12:54 am
by Mercury
Hi, Is there a way to find the date/time of compilation of a job?

Thanks

Posted: Tue Jun 29, 2010 1:07 am
by udayk_2007
you can usually see this information in DataStage Director

Regards
Ulhas

Posted: Tue Jun 29, 2010 1:19 am
by Mercury
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

Posted: Tue Jun 29, 2010 1:25 am
by ArndW
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.

Posted: Tue Jun 29, 2010 10:56 am
by kduke
Manager stores last modification time. Not sure if this gets updated after a compile.

Posted: Tue Jun 29, 2010 2:40 pm
by Sainath.Srinivasan
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.