View names

The name of the view has the following structure:
database_schema_name.object_name_V
where:
database_schema_name
Depends on the database you are using. It can assume one of the following values:
If you are using a DB2® database:
EVT
Identifies views containing information about event management object definitions.
LOG
Identifies views containing information about event management objects already run.
MDL
Identifies views containing information about the HCL Workload Automation object except event management objects.
PLN
Identifies views containing information about HCL Workload Automation objects in the plan
If you are using an Oracle database:
The name of the HCL Workload Automation Oracle user you defined during the installation.
object_name
Represents the name of the object for which you are displaying the information.
For example, if you want to display view information about job history from a DB2® database, the name of the view is:
MDL.JOB_HISTORY_V
If you want to display view information about job history from an Oracle database and the name of the HCL Workload Automation Oracle user you defined during the installation is tws, the name of the view is:
tws.JOB_HISTORY_V
Views available with HCL Workload Automation lists the views you can use with HCL Workload Automation.
Table 1. Views available with HCL Workload Automation
View name Information obtained
ACTION_PARAMETERS_V Displays information about the parameters associated with the actions run.
ACTION_RUNS_V Displays the actions run for each event rule.
CALENDARS_V Displays information about calendars.
EVENT_CONDITIONS_V Displays information about the events associated with each rule.
EVENT_RULE_INSTANCES_V Displays information about run event rule history.
EVENT_RULES_V Displays information about the event rules.
EVENT_RULE_ACTIONS_V Displays information about the actions associated with each event rule.
FILE_REFS_V Displays information about jobs and job streams that depend on a file.
INTERNETWORK_DEPS_V Displays information about jobs and job streams that depend on an internetwork dependency.
JOB_DEFINITION_REFS_V Displays information about the job streams in which a job appears.
JOB_DEPS_V Displays information about jobs and job streams that depend on a job.
JOB_HISTORY_V Displays information about job history.
JOB_STATISTICS_V Displays information about jobs.
JOB_STREAM_DEPS_V Displays information about jobs and job streams that depend on a job stream.
JOB_STREAM_REFS_V Displays information about job streams.
LOG_MESSAGES_V Displays information about the messages logged by log actions.
PLAN_DOMAINS_V Displays information about domains in the plan.
PLAN_FILE_REFS_V Displays information about jobs and job streams in the plan that depend on a file.
PLAN_FILES_V Displays information about files in the plan.
PLAN_JOB_PREDECESSORS_V Displays information about jobs and job streams predecessors of a job in the plan.
PLAN_JOB_STREAM_PREDECESSORS_V Displays information about jobs and job streams predecessors of a job stream in the plan.
PLAN_JOB_STREAM_SUCCESSORS_V Displays information about jobs and job streams successors of a job stream in the plan.
PLAN_JOB_SUCCESSORS_V Displays information about jobs and job streams successors of a job in the plan.
PLAN_JOB_STREAMS_V Displays information about job streams in the plan.
PLAN_JOBS_V Displays information about jobs in the plan.
PLAN_PROMPT_REFS_V Displays information about jobs and job streams in plan that depend on a prompt.
PLAN_PROMPTS_V Displays information about prompts in the plan.
PLAN_RESOURCE_REFS_V Displays information about jobs and job streams in plan that depend on a resource.
PLAN_RESOURCES_V Displays information about resources in the plan.
PLAN_WORKSTATIONS_V Displays information about workstations in the plan.
PROMPTS_V Displays information about prompts, such as their name and definition.
PROMPT_REFS_V Displays information about jobs and job streams that depend on a prompt.
PROPERTIES_V Displays information about global options and properties.
REMOTE_JOB_REQUESTS_V Displays the details of the request to bind to a job on a remote engine.
RESOURCES_V Displays information about resources.
RESOURCE_REFS_V Displays information about jobs and job streams that depend on a resource.
RUN_CYCLE_REFS_V Displays information about when job streams run.
VARIABLES_V Displays information about global parameters, from now on called variables.
VARIABLE_TABLE_REFS_V Displays information about job streams, run cycles, and workstations that use variable tables.