---
title: Data Load Times – ETL Schedules 
description: Opening our ETLService.config file, we can see the structure of how, what and when the data is imported.  The main config file is broken down into a few key areas. Today we’ll focus on the schedules,
---

[Skip to content](https://help.intuitivebusinessintelligence.com/data-load-times-etl-schedules#main-content)

English

Show submenu for translations

![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to weareintuitive.com](https://weareintuitive.com/)

[Go to weareintuitive.com](https://weareintuitive.com/)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en)
2. [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en)
3. [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation)

# Data Load Times – ETL Schedules 

Opening our ETLService.config file, we can see the structure of how, what and when the data is imported. 

The main config file is broken down into a few key areas. Today we’ll focus on the schedules, and with a third party tool we can minimize the areas we don’t need to focus on, such as the: 

- Config Sections 

- File System 

In the DatabaseFiles tag, we have a subsection for the tables we’re creating. 

![](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/image-png-Dec-03-2024-03-40-31-5550-PM.png?width=1139&height=264&name=image-png-Dec-03-2024-03-40-31-5550-PM.png)

These tables detail how they capture the data (See the Source tags), the Schedule, and the Fields they create (the columns in the table) 

We can ignore the first and last sections, so let’s focus on the schedule. 

The Schedule Type of Explicit remains the same, with the other value being None, however we can alter the days the schedule runs on by nominating the day tag in this field.  

The field highlighted shows the seven days of the week. You can trim this to suit your requirements, but for the schedule to run on weekdays, you can remove the values of “sa” and “su”. 

![](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/image-png-Dec-03-2024-03-41-06-6111-PM.png?width=649&height=39&name=image-png-Dec-03-2024-03-41-06-6111-PM.png)

We can set a time for this table to update by changing the 24 hour time for the *start* attribute. Typically, we load data very early in the morning so it doesn’t affect the load on the target server, and typically after the maintenance cycles on the server. 

The additional configuration we can perform includes changing the table to run multiple times per day. You can still set a start time, but it’s possible to add an end time for the ETL to stop, and an interval attribute in minutes for it to repeat the ETL update. The below example starts at 1 am, runs every 30 minutes, and stops at 4 am.

![](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/image-png-Dec-03-2024-03-42-55-3007-PM.png?width=850&height=40&name=image-png-Dec-03-2024-03-42-55-3007-PM.png)

When you’ve made your change to that table, you will need to repeat this task for any other table in the ETLService.config file. Meaning, if every table needs to run one hour later than normal, you need to move every schedule for every table forward by an hour. 

- [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content)

    - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started)
    - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards)
    - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards)
    - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters)
    - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets)
    - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components)
    - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview)
    - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components)
    - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard)
    - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system)
    - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users)
    - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups)
    - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier)
    - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward)
    - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards)
    - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file)
    - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide)
    - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history)
- [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut)
    - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content)

    - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3)
    - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3)
    - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards)
    - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs)
- [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content)

    - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation)
    - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise)
- [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content)

    - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview)
    - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps)
    - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts)
    - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse)
- [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en)
- [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content)

    - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive)
- [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content)

    - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise)
    - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning)
- [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en)
- [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content)

    - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge)
    - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information)
- [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en)
- [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en)
- [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content)

    - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections)
    - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries)
    - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds)
    - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets)
    - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability)
    - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation)

[![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en)

weareintuitive.com Help Center

Copyright © 2026, Intuitive Business Intelligence Limited