USER_STATUS not being updated in the database

[pioawd]

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?

[Ravi Kiran Kunduri]

Hi,

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