DS_AUDIT problem
Posted: Wed Sep 09, 2009 2:52 pm
Hi,
I am facing a strange problem with DS_AUDIT. I ran the following query in the Admin command prompt.
SELECT INSTANCE, DTM, MODIFIER, REASON
FROM DS_AUDIT
WHERE CLASS = '2'
AND INSTANCE = '<<Job name>>'
It gave me the results but for MODIFIER all the jobs have same user id. I thought may be all the jobs were created/modifed by the same user, So, I used a different id to copy an existing job and compiled it. Now, I ran the same query again but got no results this time. My question is, as soon as we create a new job and compile it, wouldn't the repository get updated? Do I have to to do something to refresh the repository.
Thanks for your help.
I am facing a strange problem with DS_AUDIT. I ran the following query in the Admin command prompt.
SELECT INSTANCE, DTM, MODIFIER, REASON
FROM DS_AUDIT
WHERE CLASS = '2'
AND INSTANCE = '<<Job name>>'
It gave me the results but for MODIFIER all the jobs have same user id. I thought may be all the jobs were created/modifed by the same user, So, I used a different id to copy an existing job and compiled it. Now, I ran the same query again but got no results this time. My question is, as soon as we create a new job and compile it, wouldn't the repository get updated? Do I have to to do something to refresh the repository.
Thanks for your help.