How to know ,after certain date which Job modified.

[swades]

All,

I did search the forum,but not found any reasonable focus.
I want to know after certain date ,which job has been modified?
Is there any way we can know?
Any help would be appreciated.

Thanks

[chulett]

Define 'modified'.

The Manager will show you "Date/Time Modified" but that doesn't necessarily mean anything changed.

[gateleys]

The DS_AUDIT universe file maintains such metadata.

gateleys

[swades]

The DS_AUDIT universe file maintains such metadata.

Where this file stored

[gateleys]

The DS_AUDIT universe file maintains such metadata.

Where this file stored

Its a DS repository file. You can't just open it .... its hashed.
How do you query a universe file? One simple way is to do a select all on that file from DS Admin client.

gateleys

[ray.wurlod]

Code: Select all

SELECT INSTANCE, DTM, MODIFIER, REASON 
FROM DS_AUDIT
WHERE CLASS = '2'   -- select only jobs 
AND INSTANCE = '<<Job name>>'
AND DTM >= '<<yyyy-mm-dd>>'
WHEN DTM >= '<<yyyy-mm-dd>>';

The WHERE clause restricts the result set to those jobs with a DTM in the specified range; the WHEN clause limits the display to those DTM values that match the criteria. Without the WHEN clause you will get the entire modification history of the job. Omit the restriction on job name to get all jobs.

Execute this command from the Administrator client command window or from the DataStage shell (TCL) on the server.

[swades]

Thanks to all,

It works. :D