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