DS_AUDIT problem

[Nagin]

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.

[ray.wurlod]

Version 8 doesn't always reliably record CLASS. Try with

Code: Select all

CLASS IN ('2','7')