[AWA] Which table in UC4 SQL database that holds Variable & Prompt settings for jobplan?
book
Article ID: 109872
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Which table in UC4 database that holds the "Variable & Prompt" values for jobplan?
Environment
Release: Component: AAUTEN
Resolution
The "Variable" information is stored in OV table, and "Prompt" information is stored in OPU table. The reference keys to OH_Idnr (of jobplan) are OV_OH_Idnr and OPU_OH_Idnr.
Another referent information: - The default value of the prompt itself will be in OPSE - Value of prompt if defined on object level will be in OPUD - Value is overwritten in JOBP - value will be within JPPV