Page 1 of 1
Way to Find who creates the jobs ( 7.5.2)
Posted: Wed Jul 25, 2012 1:48 am
by ithirak_17
Is there any way we can find who created the datastage job in 7.5.2 Or which user modifed the datastge job? Please advice.
Posted: Wed Jul 25, 2012 1:49 am
by ray.wurlod
This information is stored in the DS_AUDIT.CREATOR column for the creator, and in the DS_AUDIT.MODIFIER column for the modifier. Note that MODIFIER is part of an association of multi-valued fields called MODS. I suggest you search DSXchange for examples of how to query DS_AUDIT.
Posted: Wed Jul 25, 2012 1:50 am
by ArndW
There is no documented means of determining that; but there is an undocument internal hashed file in each project called DS_AUDIT which contains that information.