Contents x
    Execution trigger setting
      • Print
      • PDF
      Contents

      Execution trigger setting

        • Print
        • PDF
        Article summary

        Caution

        This setting cannot be newly created on 07/01/2024.
        Settings created prior to the above will continue to be valid, but this feature will be disabled in the future.
        Please transition to workflow.

        summary

        In the Execution Trigger Job Setting, you can create dependencies for ETL Jobs and Data Mart Generation Jobs.
        By creating dependencies, it is possible to control the order in which ETL Jobs are executed and the conditions under which they are executed.
        Example: I want to start a Data Mart Sync for Data Mart B after Job Setting A in ETL Configuration A is completed.

        important point

        The Execution Trigger function is deprecated as of April 2022.
        Please move to a Workflow function that can be operated via GUI and allows more flexibility in defining dependencies.

        subject (of taxation, etc.)

        Dependencies can be created for the following

        • ETL Job
        • data-mart think-job

        Execution Trigger Rules

        This function allows you to attach a "job" to an "execution trigger job". There are two types of jobs: ETL Jobs and Data Mart Sync Jobs.
        Multiple "jobs that trigger execution" can be attached to a "job.
        A "job" is executed when a "job that triggers execution" satisfies the following rules.

        • The "job" starts executing when all subsequent "execution-triggered jobs" have successfully completed, starting from the point at which the "job" has successfully completed.
        • Similarly, if the "job" has never been executed before, the "job" will start executing when all "jobs triggering execution" have successfully completed.

        The following are points to note

        • Job Setting" is an AND relationship, and cannot be set for an OR relationship (when one of the jobs connected to it ends successfully).
        • If any of the "jobs that trigger execution" terminate abnormally, the "job" will not start.

        How to set up execution triggers

        For ETL Configuration

        1. Click on the " Set Trigger" button from the "Set Execution Conditions" tab in STEP 3.

        image.png

        1. Select the ETL Configuration and Data Mart you wish to trigger the execution of and click on "Register".

        image.png

        For data mart settings

        1. Go to the Data Mart Configuration Details screen and click on "Trigger Execution" and then click on " Register New Trigger.

        image.png

        1. Select the ETL Configuration and Data Mart you wish to trigger the execution of and click on "Register".

        image.png

        Was this article helpful?
        What's Next