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?
Article ID: 109872
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
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
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
Feedback
Yes
No
Powered by
