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
command to get the job creation date
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
command to get the job creation date
SURESH NARASIMHA
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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>>';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA