HCL Workload Automation, Version 9.4

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

Table 1 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.