How to find Last compilation of the datastage job?

[srinivas.g]

Hi -

Can you provide syntax of how to get the Last compilation date of the job?

[soumya5891]

This can be done in the following ways.

1. Perform a advance search with that job name in designer
2. From director select that particular job and clear the state file

[chulett]

Sorry but are you sure you are answering the right question?

[qt_ky]

The same question has been discussed on existing topics:

viewtopic.php?t=118466

viewtopic.php?t=84186

viewtopic.php?t=152005

[asorrell]

I think I understand what Soumya is saying. If you clear the status file, it puts the job back in "compiled" status so the director log reports its last compilation date. However you lose all the logs.

I prefer using the Manager instead. It reports compilation date and user name.

[chulett]

Ah... forgot about that so didn't see how it applied to the question being asked. Thanks.

[kvshrao]

Go to Advanced Find and check the last modified timestamp
:D

Thanks
Rao Kuntamukkala
www.networkzindia.com

[ray.wurlod]

Go to Advanced Find and check the last modified timestamp

Last modified is NOT the same as compiled timestamp. I might work on a complex job for a number of days before my first attempt at compiling. Every time I save (which is frequent) the last modified timestamp is updated.

[ray.wurlod]

You might investigate field #31 in the JOB record in the RT_CONFIGnnn table for the job.