Page 1 of 1
find a job based on job creation date
Posted: Thu Aug 10, 2006 3:21 am
by puli.reddy
Hi All,
Can anyone tell me, how to find the server jobs based on job creation date!
Posted: Thu Aug 10, 2006 4:23 am
by loveojha2
Code: Select all
SELECT * FROM DS_AUDIT WHERE DTC> '2005-01-01' AND CLASS='2'
Posted: Thu Aug 10, 2006 5:11 am
by ray.wurlod
Or, even better
Code: Select all
SELECT INSTANCE, CREATOR
FROM DS_AUDIT
WHERE CLASS = '2'
AND DTC > '<<Earliest date,(D)>>';
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.
Posted: Fri Aug 11, 2006 12:47 am
by puli.reddy
Thanks for your early reply. Could you please tell me in detail where should I execute the above queries!
Posted: Fri Aug 11, 2006 1:47 am
by ray.wurlod
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.
Posted: Fri Aug 11, 2006 3:11 am
by puli.reddy
Thanks it works fine.