Page 1 of 1
Modified Date
Posted: Thu Oct 13, 2005 1:46 am
by VasanthRM
How do i find out when the job was last modified.........Is there any timestamps available to show it.
I want to know when the job was created and last modified? Where can i find these details.
Posted: Thu Oct 13, 2005 1:59 am
by loveojha2
Yes, you can view the timestamp (last date/time modified) from datastage manager, moreover if you want to use the timestamp of a job inside a job then you would need to use
DSGetJobInfo (JobHandle,DSJ.JOBLASTTIMESTAMP) function, where the JobHandle is the handle of that job.
Posted: Thu Oct 13, 2005 2:05 am
by loveojha2
Correction :
DSJ.JOBLASTTIMESTAMP : will tell you when the job was last run on the server.
I am not sure, do we have any provision to see when the job was first created (or saved)
Posted: Thu Oct 13, 2005 4:31 am
by ray.wurlod
Date/time created, modified and deleted are all stored in a table called DS_AUDIT. Constrain on the column called INSTANCE which, for jobs, contains the job name.
Code: Select all
SELECT DTC, CREATOR FROM DS_AUDIT WHERE INSTANCE = '<<JobName>>';
Code: Select all
SELECT DTM, MODIFIER FROM UNNEST DS_AUDIT ON MODS WHERE INSTANCE = '<<JobName>>';
Note that DataStage/SQL is case sensitive.
Posted: Thu Oct 13, 2005 6:33 am
by chulett
In addition, last modified time is displayed in the Manager. For all objects, I do believe.