DSXchange

Posted: **Mon Feb 24, 2014 8:12 am**

Is there any way to find latest compiled date of a datastage job?

Posted: **Mon Feb 24, 2014 8:23 am**

Last modification time of directory RT_SC<JOB_ID> gives the last compilation time of the job

Posted: **Wed Jan 11, 2017 1:27 pm**

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:

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 $

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.

DSXchange

How can I see the latest compiled date for a job?

How can I see the latest compiled date for a job?