Find the Last Modified Date of a Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Mon Jul 04, 2005 6:25 am
Find the Last Modified Date of a Job
Hi
Is there a way to know the last modified date of a Server Job.
Thanks and Regards
Manoj
Is there a way to know the last modified date of a Server Job.
Thanks and Regards
Manoj
-
- Participant
- Posts: 23
- Joined: Mon Jul 04, 2005 6:25 am
You can also use the contents in the DS_AUDIT Hash file to get this information. If you are not comfortable using the Administrator or command line, you could create a job and declare the DS_AUDIT hashed file along with importing the metadata for it's contents.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
If you export your job design, you can view the resulting dsx file, and see lines similar to the following:
BEGIN DSJOB
Identifier "D_DATE"
DateModified "2005-08-24"
TimeModified "11.59.29"
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 39
- Joined: Tue Dec 23, 2003 3:47 am
- Location: India
-
- Participant
- Posts: 23
- Joined: Mon Jul 04, 2005 6:25 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's in the DS_AUDIT table.
A search of the forum will yield the column names for this table and examples of how to query it. Clearly there may be more than one modification, so date/time modified and by whom are stored as multi-valued columns.
A search of the forum will yield the column names for this table and examples of how to query it. Clearly there may be more than one modification, so date/time modified and by whom are stored as multi-valued columns.
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.