ESP dSeries Workload Automation

 View Only
  • 1.  USER_STATUS not being updated in the database

    Posted Mar 13, 2024 07:14 AM

    We are running custom scripts that add service now incident number to every job failure as a USER_STATUS 

    This is not reflected in our database (postgres standalone) until there's an action done against this job (resubmission, completion etc.)

    We also run custom sql queries against the database to get failed job reports and would like to have the USER_STATUS/INC number shown in the report, is there a way for dSeries to upload the USER_STATUS to the database (esp.v_generic_job table has the user_status column) right after it's added to the job?

  • 2.  RE: USER_STATUS not being updated in the database

    Broadcom Employee
    Posted Mar 14, 2024 07:14 AM


    I am not sure how the user status is getting updated and how the value is retrieved.

    We can get the job's user status using the WOB._userstatus symbolic variable.

    Hope it helps!

    Ravi Kiran