Page 1 of 1
command to get the job creation date
Posted: Fri Feb 03, 2006 8:39 am
by suresh.narasimha
Hi
Could anybody help me to get the
command to get the job creation date.
Is any possibility to change the creation date of job.If so how to trace that who changed the creation date.
This would be a great help.
thanks in Advance
Suresh N
Posted: Fri Feb 03, 2006 8:52 am
by ArndW
There is no date field embedded in the designtime information of a job, but you can look at the DS_AUDIT table in the project repository. That file will give you an audit trail of the change history for your jobs, among other information.
The DS_AUDIT table is not described or documented and does contain fields that are "multivalued" but the file itself is not overly complex and contains all the information you want.
Posted: Fri Feb 03, 2006 2:37 pm
by ray.wurlod
Since you're new to the forum, and I'd guess even newer to DataStage SQL (especially for multi-valued fields), here's a starter pair of queries.
Code: Select all
SELECT INSTANCE, CREATOR, DTC
FROM DS_AUDIT
WHERE CLASS = '2' AND INSTANCE = '<<JobName>>';
SELECT MODIFIER, DTM
FROM UNNEST DS_AUDIT ON MODS
WHERE CLASS = '2' AND INSTANCE = '<<JobName>>';
Posted: Fri May 04, 2012 2:26 pm
by just4geeks
This really helped me! Thanks Ray!