Scheduling the AMI monitor ETL task

IEE requires the AMI Monitor ETL task to run one time per day. This task collects information that populates the Import Exceptions user interface in ARI Dashboard. To ensure that the Import Exceptions user interface always has the most current information, schedule the AMI Monitor ETL task to run daily, after the data collection window (DCW) closes.

  1. Navigate to System Operations > Task Scheduler.

  2. In the Task Type dropdown menu, select AMI Monitor ETL Task.

  3. Configure the following parameters:

    Full ETL

    Defines whether the ETL task runs in full (True) or incremental (False) mode.

    Caution: Do not set Full ETL to True except during initial system configuration or to perform a complete rebuild of the ETL tables. When set to True, define the Start Date parameter to prevent the ETL from re-running for readings already within the system.

    Set to False for any task template that runs on a recurring basis. False indicates that the ETL runs in incremental mode. The ETL queries the ConfigChange table to identify service points that have changed since the last time the ETL ran. Only the readings created since the last execution of the task are added to the ETL tables (such as DailyReadingSummary and LikeDayAlgorithm).

    Start Date

    Define the Start Date and End Date to set the time period for the data that the ETL task will process for the data mart. Only configure these dates if Full ETL parameter is set to True. If no dates are selected, the ETL rebuilds all available data. The time period is selected individually per service point channel. The Start and End Dates are used only when the Full ETL parameter is set to True, such as during initial system configuration.

    End Date

    Define the Start Date and End Date to set the time period for the data that the ETL task will process for the data mart. Only configure these dates if Full ETL parameter is set to True. If no dates are selected, the ETL rebuilds all available data. The time period is selected individually per service point channel. The Start and End Dates are used only when the Full ETL parameter is set to True, such as during initial system configuration.

  4. Configure the Common Task Template Parameters. For more information, see Task template parameters.

  5. Click Run.