Scheduling the creation of energy logs from hourly fact table data

After you have populated the hourly fact table with energy consumption data and utility rate plan information, you must schedule the Load Meter Item Staging Table ETL to run and create energy logs. Configure and activate the default job scheduler for the Load Meter Item Staging Table ETL that is included in IBM® Maximo® Real Estate and Facilities Real Estate Environmental Sustainability Impact Manager.

Procedure

  1. To access the default job scheduler, click Tools > System Setup > Job Scheduling > Job Scheduler and click to open the DEFAULT - Load Meter Item Staging Table job scheduler.
  2. Modify the details of the job scheduler and click Activate.

Results

The Load Meter Item Staging Table ETL will run as scheduled to create energy logs based on the energy consumption data in the T_TRIASSETENERGYUSEHFACT fact table.