hi,
I like if there is any option through which we can track who made changes to the DS jobs, say if a person A created a JOB A and it's been modified by Person B on XX date and Person C on YY date. Is there a way to get this information from DS using Director, administrator, designer or manager.
Appreciate any help on this
regards,
senthil
Audit information of DS Jobs
Moderators: chulett, rschirm, roy
-
AmeyJoshi14
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
As per chulett suggestion query DS_AUDIT table. 
One of the query you can use is as follows:
The first column is ID column
Second one is date at which job is created.
Third one is the user who created the job
Fourth one is Modification date.
Fifth one is the user who has modified the job.
This may help you out! :D
One of the query you can use is as follows:
Code: Select all
SELECT KEY,DTC,CREATOR,DTM,MODIFIER FROM DS_AUDIT WHERE KEY LIKE '%Job_name';The first column is ID column
Second one is date at which job is created.
Third one is the user who created the job
Fourth one is Modification date.
Fifth one is the user who has modified the job.
This may help you out! :D
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)