Default: Uses the Load Type configuration on the ETL+ main page.
Forced Load All: Forces the job’s data warehouse tables to Load All. Example: A Job executes the default delta load of a table every hour, and another Job executes a Load All on this table overnight. Load type (Job Properties panel) and the “column mappings modified” prompt sets this condition. Learn more at Job → Forced Load All.
Name. Job’s name. Double-click on a name to edit it (or use shortcut F2). By default:
The Job name is: DataSelf <entity-id> #<job-id>
When creating WTS tasks via ETL+, the task is named with this name.
When creating Windows shortcuts via ETL+, the shortcut is named with this name.
Button Icons and Actions
Run Job: Clicking this icon will give the following options:
Run Job: Run the Job now from this ETL+ session.
Run Job via Agent: Run the Job via the Agent assigned to run this Job.
Start at. Summary of when the Job is scheduled to run.
Job Icons / Actions:
Refresh Job Status. Reloads Job List information.
Expand / Collapse. Click Expand to view additional Job List columns:
Last Run. Date-time of the last run.
Next Run. Date-time of next scheduled run.
Server. The MS Windows Server Name where the Job App is running (if applicable).
Job Steps Panel
Defines the steps for each job, including ETL+ Objects, and the maintenance of the following scripts: Tableau Extracts Refresh, Command Line, and Cloud Script.
This panel lists the steps, in the order of execution, that belong to the selected job on the Job List panel to the left. In other words, running a job from the Job List panel will execute the checked step in the Job Steps panel in the listed order.
Step Checkboxes: Use the checkboxes to select the objects that will be executed by the job in the Job List panel.
Object Type. The icon indicates the type of object in the row.
Object Name: Lists the names of each ETL+ object.
Job Icons / Actions:
Move to Top or Move to Bottom. Changes the order of execution of the steps. Select a step and click to move it to the top or bottom of the list.
Move Up or Move Down. Select a step and click to move the step up or down one row.
Add Script: Click to open the pop-up script selection panel. Select one of the options and follow the prompts. For more see Type of Job Steps below.
Delete Script. Select a step and click Delete Script to delete it.
Run Script. Select a step and click Run Script to execute it.
Script Properties. Select a step and click to change it’s properties. For more see Type of Job Steps below.
Force Replace when Upsert, default for others: Forces the Job’s tables to load with the Replace load type only for tables withUpsert selected in the Load Panel on the .
For these tables, you must configure the Replace filter correctly, for instance: CreateDate>=Max(CreateDate). This filter is always different than the one used in Upsert. After you configure the Replace filter, switch back to Upsert and save it.