How can I see the latest compiled date for a job?
Moderators: chulett, rschirm, roy
How can I see the latest compiled date for a job?
Is there any way to find latest compiled date of a datastage job?
JJ
I just did some validation of this answer and realized that it is slightly incorrect (at least at 11.3 it is). The RT_SCnnn directory timestamp shows the last time the job was run. To actually get the last compile time of the job, look at the modification timestamp for the OshExecuter.sh / OshScript.osh inside the folder.
FYI - to get the job number for a job you can look in the Director log and click on a log entry to view details. The Job number is one of the fields in the message header.
For example:
In the listing above, the job was compiled at 1:10pm, and run at 1:17pm.
Please note that it is entirely possible for the other files in the directory to have older modification dates. They are typically source files for transformers and are only compiled by default if they were actually modified. If you perform a "force compile" from the Designer "File" menu it will actually compile all the source files even if they were not modified since the last compile.
FYI - to get the job number for a job you can look in the Director log and click on a log entry to view details. The Job number is one of the fields in the message header.
For example:
Code: Select all
/opt/IBM/InformationServer/Server/Projects/dstage1 $ ls -ld RT_SC803
drwxrwxr-x 2 dsadm dstage 4096 Jan 11 13:17 RT_SC803
/opt/IBM/InformationServer/Server/Projects/dstage1 $ ls -l RT_SC803
total 512
-rwxrwxr-- 1 dsadm dstage 858 Jan 11 13:10 OshExecuter.sh
-rw-rw-r-- 1 dsadm dstage 201093 Jan 11 13:10 OshScript.osh
-rwxrwxr-x 1 dsadm dstage 1093 Jan 11 13:10 V0S107_PJOB_RMS_Items_SIM_TRNS_Format_IC_UD.trx
-rwxrwxr-x 1 dsadm dstage 658 Jan 11 13:10 V0S107_PJOB_RMS_Items_SIM_TRNS_Format_IC_UD.trx.osh
-rwxrwxr-x 1 dsadm dstage 5204 Jan 11 13:10 V0S116_PJOB_RMS_Items_SIM_TRNS_Format_IC.trx
-rwxrwxr-x 1 dsadm dstage 3294 Jan 11 13:10 V0S116_PJOB_RMS_Items_SIM_TRNS_Format_IC.trx.osh
-rwxrwxr-x 1 dsadm dstage 776 Jan 11 13:10 V0S124_PJOB_RMS_Items_SIM_TRNS_Format_IC_SD.trx
-rwxrwxr-x 1 dsadm dstage 711 Jan 11 13:10 V0S124_PJOB_RMS_Items_SIM_TRNS_Format_IC_SD.trx.osh
-rwxrwxr-x 1 dsadm dstage 880 Jan 11 13:10 V0S235_PJOB_RMS_Items_SIM_TRNS_AddPath.trx
-rwxrwxr-x 1 dsadm dstage 450 Jan 11 13:10 V0S235_PJOB_RMS_Items_SIM_TRNS_AddPath.trx.osh
-rwxrwxr-x 1 dsadm dstage 2206 Jan 11 13:10 V0S77_PJOB_RMS_Items_SIM_TRNS_Format_UDAs.trx
-rwxrwxr-x 1 dsadm dstage 951 Jan 11 13:10 V0S77_PJOB_RMS_Items_SIM_TRNS_Format_UDAs.trx.osh
-rwxrwxr-x 1 dsadm dstage 4030 Jan 11 13:10 V3S0_PJOB_RMS_Items_SIM_TRNS_Format_for_XML.trx
-rwxrwxr-x 1 dsadm dstage 2804 Jan 11 13:10 V3S0_PJOB_RMS_Items_SIM_TRNS_Format_for_XML.trx.osh
/opt/IBM/InformationServer/Server/Projects/dstage1 $
Please note that it is entirely possible for the other files in the directory to have older modification dates. They are typically source files for transformers and are only compiled by default if they were actually modified. If you perform a "force compile" from the Designer "File" menu it will actually compile all the source files even if they were not modified since the last compile.