Configuring the Scheduler › Aggregate Statistics Automatically

Aggregate Statistics Automatically

You can configure CA Workload Automation AE to aggregate the job, alarm, and scheduler statistics automatically at a specified interval. The job, alarm, and scheduler statistics are aggregated into the ujo_rep_hourly, ujo_rep_daily, ujo_rep_weekly, and ujo_rep_monthly database tables. You can display these aggregated statistics in a report format in CA Workload Automation AE. Other applications, such as CA WCC, can also retrieve these aggregated statistics to generate predefined and custom reports.

The scheduler automatically aggregates the job, alarm, and scheduler statistics as follows:

• Hourly—At the start of every hour
• Daily—At midnight every day
• Weekly—At midnight on the first day of every week, taken as Sunday
• Monthly—At midnight on the first day of every month

Note: In all cases, the scheduler aggregates statistics in smaller intervals before starting the specified aggregation. For example, if you schedule a monthly aggregation process, the scheduler aggregates the hourly, daily, and weekly statistics before starting the monthly aggregation.

Follow these steps:

1. Click Start, Programs, CA, Workload Automation AE, Administrator.

   The Instance - CA Workload Automation AE Administrator window opens.

2. Select an instance from the Instance drop-down list in the Settings pane.
3. Click the Scheduler icon on the toolbar.

   The Scheduler - CA Workload Automation AE Administrator window appears.

4. Click the Options tab, select the Aggregate Statistics check box in the Settings pane, and click Apply.

   Note: By default, the Aggregate Statistics check box is not selected.

5. Click the Services icon on the toolbar.

   The Services - CA Workload Automation AE Administrator window appears, displaying a list of services installed on the selected instance.

6. Right-click the scheduler service, and click Pause.

   The scheduler pauses.

7. Right-click the scheduler service, and click Resume.

   The scheduler resumes. The statistics are aggregated automatically.

Notes:

• The scheduler does not aggregate monthly statistics for the current month, week, day, or hour. For example, if the oldest event in the ujo_proc_event table is 09/27/2011 00:05:10 and you schedule the aggregation process on 10/11/2011 at 18:30:00, the statistics are aggregated as follows:
  • Hourly statistics—From 09/27/2011 00:00:00 through 10/11/2011 17:59:59
  • Daily statistics—From 09/27/2011 00:00:00 through 10/10/2011 23:59:59 (14 days)
  • Weekly statistics—From 09/25/2011 00:00:00 through 10/08/2011 23:59:59 (two weeks)
  • Monthly statistics—From 09/01/2011 00:00:00 through 09/30/2011 17:59:59 (one month)
• You can aggregate statistics manually by sending an aggregation event using the sendevent command. You do not need to select the Aggregate Statistics check box to aggregate statistics manually. For more information about the sendevent command, see the Reference Guide.
• When aggregation is scheduled automatically, starting and completed messages are written in the scheduler log file. Detailed messages are written in the aggregation log file (aggregator.instance) located in the %AUTOUSER%/out directory. The aggregation log file has the same properties as the scheduler log file and it rolls over based on the LOGROLLOVER environment variable setting.
• If the scheduler is shut down while the aggregation process is active, the aggregation process is terminated. A message is displayed to indicate the same.
• On UNIX, the equivalent configuration parameter is AggregateStatistics.