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.