Reports

Summary of historical reports 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 Collects historical job execution data during a time interval. Helps you find:
  • Jobs ended in error
  • Jobs that ended in error and were rerun or manually set to complete
  • Late jobs
  • Missed deadlines
  • Long duration
  • Rerun indicators for reruns
  • Other historical information.
Note: a job run is not archived by the reporting feature if it terminated with one of the following error codes:
  • OSEQ, OSUF, OSUB, OSUP, OJCV, JCLI, JCL, MCP, OSSI, OSSQ, OSSS, OSSC, OFSI, OFSQ, OFSS, OFSC, SERC, SEUN, CATE, CLNO, CLNA, CLNC, or FAIL.
  • Job name, job stream name, workstation name, and workstation name (job stream). Each field can be specified using a wildcard.
  • Submission destination
  • Execution destination
  • Status (Success, Error).
  • Delay indicators
  • Job execution interval
  • Include/Exclude rerun iterations
 You can select from the following:
  • Actual start time
  • Estimated duration
  • Actual duration
  • Job identifier
  • Started late (delay)
  • Ended late (delay)
  • Status
  • Iteration number
  • Long duration
  • Error code
  • Submission destination
  • Execution destination
  • Report format:
    • Table view
    • Include table of contents
Job run statistics Collects job execution statistics. Helps you find:
  • Success/error rates
  • Minimum and maximum elapsed and CPU times
  • Average duration
  • Late and long duration statistics
  • Job name. The 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 statistics:
    • Total runs (divided in Successful and Error)
    • Total of runtime exceptions (Started late, Ended late, Long duration)
    • Minimum, average and maximum duration
  • Report format:
    • Charts view (pie, bar)
    • Table view
    • Include table of contents
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. Fields can be specified using a wildcard.
  • Submission destination
  • Execution destination
  • 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
  • Information aggregation options:
    • Workstation
    • Run date
    • Submission destination
    • Execution destination
  • Report format:
    • Charts view (bar, line)
    • Table view
    • Include table of contents by date or by workstation
Workstation workload runtimes 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:
  • Job information:
    • Workstation name
    • Actual duration
    • Status
    • Iteration number
    • Submission destination
    • Execution destination
    • Job number
  • Information grouped by:
    • Workstation
    • Run date
    • Submission destination
    • Execution destination
  • Report format:
    • Charts view
    • Table view
    • Include table of contents
Custom SQL A wizard helps you define your custom SQL query (only on the database views which you are authorized to access). The resulting report has a table with the column name as specified in the SELECT part of the SQL statement. You can either write an SQL query statement to be run, or import a file containing the SQL statement that you want to use. You can select from the following:
  • Report format:
    • Table view
    • Include SQL statement
Report types shows the available reports, and their details.
Table 2. Report types
Report Name Description Supported environment
Job Run History Collects the historical job run data during a specified time interval. Use it to detect which jobs ended in error or were late. It also shows which jobs missed their deadline, long duration jobs, and rerun indicators for reruns. Distributed and z/OS
Job Run Statistics Chart Collects the job run statistics. Use it to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics. Distributed
Job Run Statistics Table A report collecting the job run statistics, which returns output in table format. It is useful to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics. Distributed
Job Run Statistics A report collecting the job run statistics, which returns output in table format. It is useful to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics. z/OS
Workstation Workload Summary Shows the workload on the specified workstations. The workload is expressed in terms of number of jobs that ran on them. It helps for capacity planning adjustments (workload modelling and workstation tuning). Distributed and z/OS
Workstation Workload Runtimes Shows job run times and duration on the specified workstations. It helps for capacity planning adjustments (workload modelling and workstation tuning). Distributed and z/OS
Custom SQL Allows you to create reports that best fit your business needs. You can specify an SQL query or import SQL scripts. Distributed
Planned Production Details Extracts information about planned production plans into either an XML or a CSV format, to be used respectively, with Microsoft Project and Microsoft Excel. This also allows users who do not know HCL Workload Automation to access plan information in a familiar format. Distributed
Actual Production Details Extracts current plan information into either an XML or a CSV format, to be used, respectively, with Microsoft Project and Microsoft Excel. This also allows users who do not know HCL Workload Automation to access plan information in a familiar format. Distributed
Analysis Job Duration Estimation Error A report that shows the average estimation error. It is useful to detect whether a job ends in frequent errors, ends in error, or if the jobs have unsatisfactory accuracy rates. You can then drill down to display all the jobs that are in that threshold and finally you can visualize charts that will help you to identify the jobs that have a high estimated error rate allowing you to intervene beforehand on those jobs. Distributed and z/OS
Analysis Job Duration Standard Deviation A report showing variances in job duration. The variance is calculated as a percentage and according to which variance level the jobs are they will be presented as follows: High variability, Medium variability or a Low variability. You can drill down to display all the jobs that are in that threshold which then returns output in a chart format. This report is useful to identify the run that had a greater duration. Distributed and z/OS