AutoSys Workload Automation

 View Only
  • 1.  Query to List Jobs Details by UserId?

    Posted Sep 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?



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

    Broadcom Employee
    Posted Sep 08, 2016 03:45 PM
      |   view attached



    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.