ESP dSeries Workload Automation

 View Only
  • 1.  SQLI variable object from Process Monitoring

    Posted Aug 11, 2020 05:55 AM
    Hello,

    I need to get information about active jobs in process monitoring tab with status.
    For it I created SQLI variable:
    select EH_Name, EH_Status, EH_Client from EH
    it looks so, for example:

    this information I will use in promptset object, but I would like to change code status 1800 to it's text status ENDED_NOT_OK - Aborted.
    It should look like in RESULT field:
    CREATE-FILE2.SRS.JLIN - ENDED_NOT_OK - Aborted
    Please any idea?

    Regards,
    Georgiy


  • 2.  RE: SQLI variable object from Process Monitoring

    Broadcom Employee
    Posted Aug 12, 2020 08:22 AM
    Hi,
    Looks like your question is about Process Monitoring/ Process Automation.  Your post got opened in Workload Automation.  You may want to post it again in Process Automation community.

    HTH,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 3.  RE: SQLI variable object from Process Monitoring

    Posted Aug 12, 2020 08:26 AM
    Hi, already opened.

    Georgiy