Query to List Jobs Details by UserId?

[FernandoB Romero]

I know that there is a userID filed on ESP_GENERIC_JOB database but looking at the values in there, it indicates user.PRIMARY. I wanted to create a query to list all jobs executed by certain userIDs. is this userID mapped somewhere else?

 

Thanks.

[Olusegun Oduntan]

Ferdie,

 

I was able to verify that the esp_generic_job userid field stores the DE id and DE user for jobs that are forced to completion. If you need to get the information in the job definition uploaded to the DE Server, you can look in the DEFINITION field in ESP_AMS_DF table where artifacttype=’Application’. The job definitions are stored in clob format. Alternatively, you can export the application artifact using the imexutil utility and parse the file.

 

Regards,

Segun