Search
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.
How helpful was this page?
Thank you! We've received your feedback.