Hi All,
Can anyone tell me, how to find the server jobs based on job creation date!
find a job based on job creation date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Wed Jan 11, 2006 8:29 pm
- Location: Singapore
- Contact:
find a job based on job creation date
Thnaks and Regards,
AnjiReddy.
AnjiReddy.
Code: Select all
SELECT * FROM DS_AUDIT WHERE DTC> '2005-01-01' AND CLASS='2'
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Or, even better
DS_AUDIT is a DataStage table that records the date/time and by whom each object was created, modified and deleted. It has no exposure in any of the clients, so you need to execute a query against the Repository database.
This query can be executed via the Administrator client Command window, or in a telnet session to the server in a dssh shell. Note also that the identifier names in DataStage/SQL are case sensitive.
Code: Select all
SELECT INSTANCE, CREATOR
FROM DS_AUDIT
WHERE CLASS = '2'
AND DTC > '<<Earliest date,(D)>>';
This query can be executed via the Administrator client Command window, or in a telnet session to the server in a dssh shell. Note also that the identifier names in DataStage/SQL are case sensitive.
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.
-
- Participant
- Posts: 28
- Joined: Wed Jan 11, 2006 8:29 pm
- Location: Singapore
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage Administrator client.
Projects tab.
Select your project.
Click Command button, which opens Command window.
Execute command there. Make sure that spelling and casing are accurate.
Projects tab.
Select your project.
Click Command button, which opens Command window.
Execute command there. Make sure that spelling and casing are accurate.
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.
-
- Participant
- Posts: 28
- Joined: Wed Jan 11, 2006 8:29 pm
- Location: Singapore
- Contact: