This topic describes how to create a workflow in a workspace to periodically execute tasks.
Background information
An OceanBase Cloud workflow consists of multiple user-defined computing nodes that are combined in the order defined by the user. The system periodically executes the task based on the user's configuration.
Create a workflow
Log in to the OceanBase Cloud console. In the workspace list, click the name of a workspace to enter the workspace.
On the workspace page, choose Workflows > Create Workflow.
On the workflow page, click + Add Node in the toolbar to add a node and select the node type. Configure the node attributes and click the
icon in the toolbar to save the node attributes.SQL node
Parameter Description Node Name Enter a name for the node. SQL Worksheet Select an SQL worksheet or create a new one. Database Select a database in the current workspace under the analytical instance. Retry Attempts Enter the number of retries on failure. Retry Interval Enter the retry interval. Offline data synchronization
Parameter Description Node Name Enter a name for the node. Source Select the source database and specify the filter conditions. Target Select the target database, data write mode, and SQL statements to be executed. Task Configurations Specify whether to ignore task errors and continue, and whether to throttle task execution. Import cloud storage files
Parameter Description Node Name Enter a name for the node. Source Select the import file. Target Select the target database, data write mode, and SQL statements to be executed. Task Configurations Specify whether to ignore task errors and continue, and whether to throttle task execution.
Click Workflow Settings to set workflow attributes and click the
icon in the toolbar to save the workflow attributes.Parameter Description Workflow Name Enter a name for the workflow. Compute Node Select or create a compute node. Only compute nodes of the same cloud vendor and region as the current workspace instance are supported. You can create a compute node in the compute node pool on the OceanBase Cloud console. Execution Schedule Select the execution time. Effective period Select the effective period of the workflow. Retry Attempts Enter the number of retries on failure. Retry Interval Enter the retry interval. Remarks Enter the business background information of the project. Note
You can double-click or right-click the workflow name in the SQL window to rename the workflow.
Click the Deploy button. In the Deploy Workflow dialog box, click OK.
After the workflow is generated, you can view its information in the Workflows list.
View a workflow
In the workflow list, you can click ... > Undeploy in the Actions column to undeploy the workflow.
View basic information
In the workflow list, click the workflow name. On the Basic Information tab, view the information such as the associated compute node, creation time, update time, creator, and remarks.
View execution history
In the workflow list, click the workflow name. On the Execution History tab, view the task status and execution details, and perform related operations.
Also, you can filter the workflows under the Execution History tab in the left-side pane to view the execution history of a specific workflow.
Execute a workflow
On the Create Workflow page, you can click the Executions button in the toolbar to run, deploy, or undeploy the workflow.