All Products
Search

This Product

    Basic concepts

    Document Center

    Basic concepts

    Last Updated: May 28, 2020

    Task

    • A task is a node that can complete a functional operation.
      • Currently, the following tasks are supported:
        • SQL tasks within a single instance
        • SQL tasks that require interaction across different databases
        • Data synchronization tasks

    Task flow

    • A task flow is a collection of multiple tasks that are grouped and orchestrated into a directed acyclic graph (DAG).
      • You can enable periodic scheduling such as daily, weekly, monthly, and annual scheduling in the scheduling configuration.

    Role

    • Owner: Only the owner of a task flow has the permissions to edit the task flow and task configurations. The owner can also perform a dry run on tasks and receive task running alerts.
    • Stakeholder: A stakeholder of a task flow has the permissions to view the task flow and task configurations and perform a dry run on tasks. However, a stakeholder does not have the permissions to edit the task flow and task configurations.
    • Administrator and DBA: In addition to the permissions of a stakeholder, the administrator and DBA have the permissions to edit and reassign the owner of a task flow.

    Running permission

    • Whether a task flow can be run depends on the database and table permissions owned by the owner of the task flow. If the owner does not have permissions on a certain database or table, the task flow will fail even if the person currently running the task flow has access to the corresponding database or table.
      • Only the owner, stakeholders, administrator, and DBA can run a task flow.

    Running instance

    • A running instance is generated each time a task flow is run.
      • The Running Configuration tab lists all running instances. You can manage the running instances, including re-running, terminating, suspending, or resuming a running instance or setting the status of a running instance to successful.

    Running time

    • The running time indicates the time when a task was run, in UTC+8.

    Business time

    • The business time is one day before the running time by default. It is represented by the bizdate system variable.

    Custom task variables

    • Custom variables are used to run SQL tasks at different time to achieve different results. DMS Enterprise allows you to set custom variables for SQL tasks. A custom variable indicates an offset relative to the bizdate system variable.