Building the first job

From the ETL Tool version 2021.05_610.125 onwards, the behaviors of the three stages, TableInput, DatalakeInput and StagingUpsert, are aligned. When an issue occurs, the whole transformation fails and the job fails as well.

To build the first job:

  1. In the Spoon dialog box select File > New > Job.
    Alternativity, you can click the + icon and click Job.
  2. Add a Start stage to the General folder, always end a job with a Success step.
  3. Select the Start step and double-click the Transformation to specify the Job entry details.
    When you have added the last step, ensure to double-click the Success step. See this diagram:
    ../images/image5.png
  4. Select the Specify by name and directory check box and click OK.
  5. Click the Run icon.
  6. Specify a name, for example job_total and save the job.
    On the Logging tab in the Execution Results section you can find useful information such as query id for Compass or payload id from payloads and so on.
    For this job to be set as a schedule job in the task scheduler, you can find an example bat file in this folder:
    catalog deem_setup/jobs
    The job name is mi_prd_total.cmd