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.
Modified Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Note that DataStage/SQL is case sensitive.
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>>';
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.