List of jil attributes

Document ID : KB000044115
Last Modified Date : 14/02/2018
Show Technical Document Details


We would like a listing of all possible jil attributes for all Workload Automation AE job types. Is the a way to get such a list dynamically?



Workload Automation AE 11.3.x

Database - Oracle

Platform - ANY



Workload Automation AE does not have a command which automatically generates a listing of all job attributes.  The jil command is designed to allow users to insert, update and delete Workload Automation jobs, machines, xinstance definitions etc...  It will validate the entries passed to it and if something invalid was entered, errors will be displayed making the user aware of the problem.  The valid jil attributes for jobs are documented in the reference guide for the product as well as on the wiki site. or


Additional Information

The ujo_meta_properties table in the database contains all jil attributes and more.  Be aware it includes attribute listing for job, machine, xinstance definitions, etc... as well as internal fields not exposed to users via normal jil syntax.

select distinct(jil_name) from ujo_meta_properties order by jil_name;

CA recommends to not rely on queries and information extracted from the Workload Automation AE database as the tables and contents can and will change from version to version.  The tables are intended to be used by the product, not for client created scripts and/or applications.