Breadcrumbs

ETL+ Web Job Page

Job List and Controls

image-20260523-221501.png

  • Entity: Shows the <Entity PK> - <Entity ID>. On the sample screenshot: 1241 - demo_etl_plus

  • Job ID

  • Job Enable/Disable toggle and filter. Disable will prevent it from running. Click the filter to view all Jobs enabled or disabled.

  • Run Job icon and filter. Click this icon to run a Job on demand. Click the filter to view all Jobs ready or running.

  • Stop Job icon and filter. Click this icon to stop a running Job. Click the filter to view all Jobs ready or stopping.

  • Properties icon. Click it to expand the Job Properties panel. See more in the next sections.

  • Job Step icon. Click it to open the Job Step panel. See more in Job Step section below.

  • Job Name

  • Job Status

  • Job Schedule Enable/Disable toggle and filter.

  • Next Run schedule (only shows when the Job and its Schedule are enabled); customize the time zone with the TZ dropdown.

  • Job Load Type dropdown and setting per job

  • Last Date Time Start; customize the time zone with the TZ dropdown.

  • Master Device status and filter.

  • Master Device’s ETL+ Windows Service status and filter.

  • Delete Job icon.

  • Device name and filter.

  • <Data warehouse SQL instance>.<database name> and filter.

  • New Job + button.

Job Properties

Click the Properties icon (wrench icon) to open the Job Properties panel:

image-20260523-221917.png

  • Job name box to rename it.

  • Load Type dropdown.

  • App dropdown: Device Master by default, or Command Line.

  • Watchdog Alert dropdown.

  • Schedule dropdown to define Daily, Weekly, or Monthly.

    • Start: Schedule start date.

    • Recurs every: enter an integer that applies to the schedule. For instance, set a Daily or Weekly schedule to recur every 2 days to run it every other day or week.

    • Toggle the Repear task every ON/OFF to enable running the Job within a day. See below an example showing a Job starting at 7am and running it every 30 minutes for 12 hours.

image-20260523-221957.png

Example of a Monthly schedule configuration:

image-20260523-222025.png

Example of a Weekly schedule configuration:

image-20260523-222044.png

Job Step Panel

Click a Job Step icon to view and manage its Job Steps.

image-20260523-230544.png

  • Close and Confirm buttons

  • Title shows Steps (<Entity ID>, <Job ID>), the sample screenshot shows (demo_etl_plus, 2)

  • All Tables checkbox will always include all target tables into the Job.

  • Selected checkbox: select multiple Job Steps and click this check box to Check/Uncheck Steps in bulk.

  • Icons to view/hide Job Steps based on their type:

    • Included Step

    • Target Table

    • Tableau data source

    • Cloud script

    • Command line

    • Export to CSV

    • Power BI semantic model

    • Job Step Label

    • Python script

  • Enable/Disable checkbox

  • Object Icon and Name

Job Step Configuration

Click the top icons to show/hide steps based on their type.

  • Popular: Click the Show Unchecked icon (first on the left) to view and hide unchecked steps.

  • Select one or several steps (use the Ctrl or Shift keyboard keys plus the mouse left click for multiple selection), and then:

    • Drag them up/down on the Step list.

    • Click the ^ v icons (on the top right) to move the selected Step(s) up or down one step, or move to the top or bottom of the list.