AutoSys Workload Automation

Expand all | Collapse all

Query to List Jobs Details by UserId?

  • 1.  Query to List Jobs Details by UserId?

    Posted 09-08-2016 12:40 PM

    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.



  • 2.  Re: Query to List Jobs Details by UserId?

    Broadcom Employee
    Posted 09-08-2016 03:45 PM
      |   view attached

    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