BODS job requested by id?

[Former Member]

Hello,

In my BODS project, I'm trying to get the "job requested by id" into a global variable. For example, if I try to execute a job from my Designer, I would like to get my windows user id into that global variable. If some one of trying to execute a job from management console, I would like to get the windows user id of that machine. If the job is being executed from a 3rd party scheduler, I would like to get the windows user id of that machine. I'm not sure if this possible in Data Services. But, can you please let me know if this can be done in DS?

Thanks

Pradeep

[former_member213365 · Accepted solution]

I'm pretty sure that what you want is not available.  You may be able to tell if it was Designer or not by looking in the AL_HISTORY table.

[ankit_sharma88]

Hello Pradeep,

As suggested by Jim you can get the Machine and the Server details which was used to run the job by querying the ALVW_HISTORY table in the metadata. If you are connecting DS using a client remote desktop then each desktop is assigned to a specific user. You can map the Machine number to the User. Store the machine and user mappings in a table and fetch the info required.

Regards,