HCL Workload Automation, Version 9.4

Historical reports

The following table summarizes the historical reports in terms of their:
  • Functionality
  • Selection criteria
  • Output content options
Table 1. Summary of historical reports
Report name Description Selection criteria Output content options
Job run history

Corresponds to Report 07.

Collects historical job execution data during a time interval. Helps you find:
  • Jobs ended in error
  • Late jobs
  • Missed deadlines
  • Long duration
  • Rerun indicators for reruns
  • Other historical information.
  • Job name, job stream name, workstation name, and workstation name (job stream). Each field can be specified using a wildcard.
  • Status (Success, Error, Unknown)
  • Delay indicators
  • Job execution interval
  • Include/Exclude rerun iterations
 You can select from the following:
  • Actual start time
  • Estimated duration
  • Actual duration
  • Job number
  • Started late (delay)
  • Ended late (delay)
  • Status
  • Critical latest start
  • Critical
  • Promoted
  • Long duration
  • Job definition name
  • CPU consumption (not available on Windows workstations)
  • Logon user
  • Rerun type
  • Iteration number
  • Return code
The output is in table view.
Job run statistics

Corresponds to Report 01.

Collects job execution statistics. Helps you find:
  • Success/error rates
  • Minimum and maximum elapsed and CPU times
  • Average duration
  • Late and long duration statistics
Note: The report does not include jobs that were submitted using an alias name.
  • Job name, workstation name, and user login. Each field can be specified using a wildcard.
  • Percentage of jobs in Success, Error, Started late, Ended late, and Long duration
  • Total runs and total reruns
 You can select from the following:
  • Job details:
    • Logon user
    • Job creator
    • Description
    • Script
    • Recovery information
  • Job statistics:
    • Total runs (divided in Successful and Error)
    • Total of runtime exceptions (Started late, Ended late, Long duration)
    • Minimum, maximum and average duration and CPU times (for successful runs only)
    • CPU consumption (not available on Windows workstations)
  • Report format:
    • Charts view
    • Table view
    • Include table of contents by job or by workstation
Workstation workload summary Provides data on the workload in terms of the number of jobs that have run on each workstation. Helps making the necessary capacity planning adjustments (workload modeling, and workstation tuning).
  • Workstation names. Each field can be specified using a wildcard.
  • Date ranges or specific days for workload filtering.
  • Relative time intervals (allows to reuse the same report task for running each day and getting the report of the production of the day before)
 You can select from the following:
  • Workstation information granularity arranged by:
    • Hour
    • Day
    • Production day
  • Information aggregation options:
    • Provide cumulative and aggregated workstation summary information for all or a subset of workstations
  • Report format:
    • Charts view
    • Table view
    • Include table of contents by date or by workstation
Workstation workload runtimes

Corresponds to Report 08.

Provides data on the job runs (time and duration) on the workstations. Helps making the necessary capacity planning adjustments (workload modeling, and workstation tuning).
  • Job and workstation names. Each field can be specified using a wildcard.
  • Workload execution period
  • Daily time intervals
 You can select from the following:
  • Information grouped by:
    • Workstation
    • Run date
    Can be ordered by rerun iteration
  • Production day
  • Job information:
    • Actual duration
    • Status
    • Rerun iteration
    • Job definition name
  • Report format:
    • Charts view
    • Table view
Custom SQL A wizard helps you define your custom SQL query (only on the database views which you are authorized to access). The criteria specified in the custom SQL query. The resulting report has a table with the column name as specified in the SELECT part of the SQL statement.