Page 1 of 1
How to find Last compilation of the datastage job?
Posted: Mon May 05, 2014 12:57 pm
by srinivas.g
Hi -
Can you provide syntax of how to get the Last compilation date of the job?
Re: How to find Last compilation of the datastage job?
Posted: Tue May 06, 2014 12:22 pm
by 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
Posted: Tue May 06, 2014 4:00 pm
by chulett
Sorry but are you sure you are answering the right question?
Posted: Tue May 06, 2014 7:10 pm
by qt_ky
Posted: Wed May 07, 2014 11:43 am
by 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.
Posted: Wed May 07, 2014 11:49 am
by chulett
Ah... forgot about that so didn't see how it applied to the question being asked. Thanks.
Posted: Wed May 07, 2014 1:45 pm
by kvshrao
Go to Advanced Find and check the last modified timestamp
:D
Thanks
Rao Kuntamukkala
www.networkzindia.com
Posted: Wed May 07, 2014 5:02 pm
by ray.wurlod
kvshrao wrote: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.
Posted: Wed May 07, 2014 5:15 pm
by ray.wurlod
You might investigate field #31 in the JOB record in the RT_CONFIGnnn table for the job.