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

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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.

Environment

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component:

Resolution

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.