HCL Workload Automation, Version 9.4

Displaying a view on a Windows workstation with an Oracle 11g schema

To display a view on a Windows workstation with an Oracle 11g schema installed, perform the following steps:
  1. Verify that the Oracle Enterprise Manager Console is accessible from a client browser. This implies that the dbconsole process is running on the server. This process starts automatically after the installation. To verify that the dbconsole process is running, and start it if it is not running, perform the following steps:
    1. Select Start → Settings → Control Panel → Administrative Tools → Services. The Services (Local) window opens.
    2. Locate the OracleDBConsoleORACLE_SID service, where ORACLE_SID is the name of the Oracle database created on the workstation. The Status column shows the status of the service.
      If the Status column is Started:
      The dbconsole process is running on the server.
      If the Status column is blank, the process is stopped. To start it, perform the following steps:
      1. Double-click the OracleDBConsoleORACLE_SID service row. The OracleDBConsoleORACLE_SID Properties (Local Computer) dialog displays.
      2. In the General page, ensure that the Startup type is either Automatic or Manual.
      3. In the Service status group, click Start.
  2. Select Start → Programs → Oracle-installation_name → DatabaseControl- database_name. The Oracle Enterprise Manager 11g Login to Database database_name web page displays.
  3. Type the following information and click Login:
    Username
    It can be:
    Oracle administrator user
    The database administrator user name, for example SYSTEM, required to authenticate to the Oracle database.
    HCL Workload Automation user
    The owner of the HCL Workload Automation schema.
    Password
    The password associated with the user specified in the Username field.
    The Database Instance: database_name home page displays.
  4. In Related Links, select SQL Worksheet. The SQL Worksheet: database_instance_name web page displays.
  5. In the Enter SQL commands input area, enter the following command: 
    select * from view_name
    where view_name is the name of the view from which you want to display the information. The view name has the following format: 
    username.JOB_HISTORY_V
    where username is the name of the owner of the HCL Workload Automation schema. For example, if the user name is TWSuser, to extract information from the username.JOB_HISTORY_V view, enter the following command: 
    select * from TWSuser.JOB_HISTORY_V
  6. Click Execute. The output area displays the results of the query.