How to find out which user deleted a particular job?

[karthikgk0705]

Hi,
We have a strange problem.
At times some or the other jobs are found missing in the project .
Is there any way to find out who has deleted that particular job?
Thanks in advance.

[chulett]

Only if that's something recorded in the DS_AUDIT table and I'm not sure if it is off the top of my head. Do an Exact match search of the site for DS_AUDIT, one of the existing posts should answer your question I would think.

[loveojha2]

At times some or the other jobs are found missing in the project .

Or the reason could be corruption of the (index) of datastage specific hashed files (sometimes such cases happened with us also) like DS_JOBS etc. Perhaps something that can't be logged.

[kumar_s]

You can track it by enabling the Server Side tracking from Adminstrator client. But it will record whole bunch of other activities as well.

[loveojha2]

Hey Kumar, I saw the tracing file that you are reffering to, but I am not really sure if any body can actually understand it and use it. Its huge and very difficult to make sense of what is really logged.

Did you get any chance any time to use it for such purposes?

[kumar_s]

We faced the same problem once and enabled the trace, but the other effect of the track made us to feel more irritated than secured. And forced us to concentrate on Version control.

[ray.wurlod]

DS_AUDIT does record the most recent time that an object was deleted, and by whom. Of course, if everyone logs in using the same user ID, that's not much help, though you can establish the time.

LIST.DICT DS_AUDIT to get the column names for your query - from memory you need LAST.DELETED and DELETOR (something like that anyway). Constrain WHERE @ID LIKE '%<<Job Name>>%'

[kumar_s]

PREVDELETOR and PREVDTD gives the user and the Date on which the job has been deleted.