find a job based on job creation date

[puli.reddy]

Hi All,

Can anyone tell me, how to find the server jobs based on job creation date!

[loveojha2]

Code: Select all

SELECT * FROM DS_AUDIT WHERE DTC> '2005-01-01' AND CLASS='2'

[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.

[puli.reddy]

Thanks for your early reply. Could you please tell me in detail where should I execute the above queries!

[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.

[puli.reddy]

Thanks it works fine.