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.