Automic Workload Automation

 View Only
  • 1.  TO PULL THE LIST OF UC4 JOBS (RUNNING, COMPLETED)

    Posted Jul 10, 2020 08:32 AM
    Hi Team

    We would like to extract the list of UC4 JOBS which are running & completed successfully from the Oracle Database.

    This will makes us our monitoring easy. Could you pls help me to share the oracle query to pull the list of UC4 JOBS (JOBP, JOBS) which are running currently & completed.

    thanks


  • 2.  RE: TO PULL THE LIST OF UC4 JOBS (RUNNING, COMPLETED)

    Posted Jul 10, 2020 12:26 PM
    Hi,

    instead of querying the database using sql statements have you already tried to use the AE Reporting tool?

    regards,
    Peter


  • 3.  RE: TO PULL THE LIST OF UC4 JOBS (RUNNING, COMPLETED)
    Best Answer

    Posted Jul 10, 2020 01:52 PM
    Active tasks are in the EH table.
    Completed tasks are in the AH table.

    https://docs.automic.com/documentation/WEBHELP/English/all/components/AE/latest/DB%20Schema/db/_structure/HTML/index.htm

    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------