Knowing the job creator

info_ds · Post by **info_ds** » Fri Jan 05, 2007 8:36 am

Hi All,

In a project i want to know the creator of each job.I have tried querying the DS_AUDIT table ,but i could not get the correct information.

Thanks in advance

chulett · Post by **chulett** » Fri Jan 05, 2007 9:08 am

What's incorrect about the information you found there?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 05, 2007 2:07 pm

What query did you issue against the DS_AUDIT table? How did you issue the query (from what environment)?

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 05, 2007 2:54 pm

Like mentioned by Craig and Ray, you need put forth more information to get a better understanding of your problem and thus the solution.

Whale.

DeepakCorning · Post by **DeepakCorning** » Fri Jan 05, 2007 4:52 pm

All , Just wanted to know tht what will get stored in DS_AUDIT if we create a job after logging in by Omitting the Password ??

May be that what he means that he is not getting correct info.

chulett · Post by **chulett** » Fri Jan 05, 2007 4:55 pm

We can guess all day, but that option is only valid on a Windows server. I counsel patience.

DeepakCorning · Post by **DeepakCorning** » Fri Jan 05, 2007 8:34 pm

Oops..sorry guys.... I am still wondering wht will happen in this case in Windows....

ray.wurlod · Post by **ray.wurlod** » Fri Jan 05, 2007 9:43 pm

Checking the Omit check box manages your authentication by passing the Windows SID with which you are logged in to the client to the other machine (the DataStage server). Therefore, one would assume, that user ID will be the owner of any job created in such a connection.

Try it. Let us know.