Page 1 of 1

Modification History of Datastage Job

Posted: Tue Feb 10, 2009 1:16 am
by neeraj
Hello everyone,

I need your help.

I want to know the solution of below mentioned scenerio.
#############################################
Job name A is created by user test, which gets modified by number of users and after then one of the user delete the job from the repository.

It will be very easy to fetch the modification history of the job using DS_AUDIT table including the name of the person who deleted the job.

But if the job gets re-imported by some other user with the same name, all the history related to the modifications done on the job starting from creation to deletion of jobs goes away from DS_AUDIT table and there will be only 1 entry stating that Job has been imported by username and time.

Is it possible to fetch the complete history of the job at any point of time?
If yes then how?

######################################
Regards
Neeraj

Posted: Tue Feb 10, 2009 5:01 am
by ray.wurlod
No. That's why the column in DS_AUDIT is called "last deleted date".