How to list jobs modification dates?
Moderators: chulett, rschirm, roy
How to list jobs modification dates?
Hi
We need to get the list of modified datastage jobs in a text file. Is there a command to list jobs modification dates?
We need to get the list of modified datastage jobs in a text file. Is there a command to list jobs modification dates?
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
The DS_AUDIT hashed file contains this information. You could get this information by executing the following command from TCL:
LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER
If you want to put this into a text file, you could write a Server job to read this file and write it to a text file. The "DTM" (date-time-modified, position 5) column and the "MODIFIER" (pos 6) column are both multivalue fields.
LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER
If you want to put this into a text file, you could write a Server job to read this file and write it to a text file. The "DTM" (date-time-modified, position 5) column and the "MODIFIER" (pos 6) column are both multivalue fields.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You can execute TCL commands from .bat scripts and get that data. CD to your project directory and then "uvsh.exe LIST DS_AUDIT BY.DSND DTM BREAK.ON INSTANCE DET.SUP MAX DTM MODIFIER NO.PAGE". The output goes to stdout and can be processed from your .bat script.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Exploded. DTM is a multi-valued field. The equivalent SQL query is
Code: Select all
SELECT INSTANCE, DTM COL.HDG 'Last modified', MODIFIER FROM UNNEST DS_AUDIT ON MODS WHERE CLASS = '2' ORDER BY DTM DESC, INSTANCE;
Last edited by ray.wurlod on Sat Oct 16, 2010 5:09 pm, edited 1 time in total.
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.