Page 1 of 1
How to find the username who has last modified the job
Posted: Tue Feb 12, 2013 12:33 pm
by diipanjan
Is there any DataStage function which I can use to get the name of the user who has last modified a datastage job?
Posted: Tue Feb 12, 2013 1:00 pm
by techiexavier
In designer, select advanced in Find options there you will get options for last modified.
Posted: Tue Feb 12, 2013 3:33 pm
by ray.wurlod
Well, yes and no. Advanced Find allows a slightly different question to be answered; which jobs were last modified by user X. I don't think this is what dipanjan was seeking.
As far as I am aware there is no way in any of the clients to determine who created or who last modified a job. This information is clearly kept, since it can be used as filter in Advanced Find.
(I was wrong - see below)
The following queries can report the creation and modification information respectively. They can be issued through the Administrator client Command window.
Code: Select all
SELECT INSTANCE, CREATOR, DTC FROM DS_AUDIT WHERE CLASS = '2';
SELECT INSTANCE, MODIFIER, DTM FROM UNNEST DS_AUDIT ON MODS WHERE CLASS = '2' ORDER BY INSTANCE ASC, DTM DESC;
Posted: Tue Feb 12, 2013 4:10 pm
by BillB
Try this - in Designer:
- Open quick find
Enter the job name, click Find
Click the '1 match' link
Posted: Tue Feb 12, 2013 4:21 pm
by ray.wurlod
Nice.
You may need to expand the Advanced Find result window horizontallly (or scroll right) to get to the modifier and dtm information.