ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
[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