Which database table do I need to use to get the User ID that a job runs as?

Document ID : KB000015845
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Which database table do I need to use to get the User ID that a job runs as? The USERID field in ESP_GENERIC_JOB table seems to store the user that created the job not the one it runs as.

Answer:

The User ID that a job runs as is not stored historically. You can find the information in ESP_WSS_JOB table at WOBGEN_AFM column.