All Products
Search
Document Center

:SQL plan task

更新時間:Mar 07, 2023

Background information

OceanBase Developer Center (ODC) can periodically execute SQL scripts created by users to complete database development and O&M tasks as required by the users. For example, ODC can periodically execute stored procedures, backup, and database and table schema synchronization.

After a user creates an SQL plan task in Task Center, the administrator can approve the task on the Tasks page in Task Center. The user can view the task information and approval status on the Tasks page in Task Center.

This topic describes how to create and manage SQL plan tasks in ODC.

Task list

Note

The task list displays the tasks created in the last 336 hours.

After you enter the target database connection, click Task Center in the top navigation bar to open the Task Center panel. Click the SQL Plan tab to view the SQL plan tasks.

SQL%20plan%201

The following table describes the columns contained in the task list on this tab. You can filter and sort the tasks in the list.

Column

Description

No.

The ID of the task.

You can click the search icon Searchto search for and filter tasks by ID.

Connection

The name of the database connection to which the task belongs.

You can click the filter icon Filterto filter tasks by connection.

Execution Period

-

Next Execution Time

The time when the SQL plan task is to be executed the next time.

Created By

The user who created the task.

You can click the search icon Searchto search for and filter tasks by creator.

Updated At

The date and time when the task was generated.

Status

The current status of the task. ODC provides different management actions for tasks in different states.

Actions

The task management actions, including ViewApprove/Reject, Edit, and Enable/Disable.

  • View: You can click this button to view task information on the task details page.

  • Approve/Reject: You can click this button to approve or reject the task.

  • Enable/Disable: You can click this button to enable or disable an ongoing task.

Create an SQL plan task

  1. In the Task Center panel that appears, click the plus sign (+) on the right of SQL Plan to create an SQL plan task.

    SQL%20plan%20-%20Create%202
  2. In the Create SQL Plan panel, specify the following information.

    SQL%20plan%20-%20Create%203

    Item

    Description

    SQL Content

    You can specify SQL content in either of the following ways:

    • SQL Entry: This is the default way to specify SQL content. You can directly write the SQL script in the editing area.

    • The maximum size of the SQL statements that can be entered in the SQL window is limited to 10 MB. If the content to be entered is more than 10 MB in size, you can directly upload an attachment.

    • You can click IN Value Conversion to convert the batch copied data into the in('A','B') format.

    • Column values are separated with line breaks.

    • Row values are separated with spaces or tabs.

    • Upload File: Click the file pool to go to the file explorer and select the file to be imported. You can also directly drag the file to the file pool to upload it.

    • You can upload up to 500 files. The total file size cannot exceed 256 MB.

    • By default, files are sorted by the order in which they were uploaded. You can drag and drop them to change the order. Tasks are executed in the file order.

    • Only SQL files suffixed with .sql are supported.

    Delimiter

    The delimiters are supported.

    Query Result Limit

    You can set the maximum number of rows allowed in the query result. Value range: 1 to 1000000.

    Execution Timeout Value

    Specify the value in the Execution Timeout Value field in hours. Default value: 48. Maximum value: 480.

    Scheduled Period

    • You can directly select a predefined option of Every Hour, Every Night, or Every Friday.

    • You can also set the scheduled execution period in either of the following modes:

      • Default: You can set the scheduled execution period on a daily, weekly, or monthly basis as needed.

        SQL%20plan%20-%20Scheduled%20execution%20period%20-%20Default%20mode%204
      • Custom: You can set the scheduled execution period by specifying the second, minute, hour, day, month, or week as needed.

        SQL%20plan%20-%20Scheduled%20execution%20period%20-%20Custom%20mode%205

    Task Settings

    You can handle task errors in either of the following ways:

    • Abort Task: This is the default option. When you select this option, the task is aborted if an error occurs when you run the script.

    • Ignore Error and Continue: When you select this option, the system skips the statement where an error occurs and continues to execute other statements in the script.

    Remarks (Optional)

    You can enter a description of up to 200 characters.

  3. Click Create to complete the task application.

    Note

    After you submit the application, the task will automatically match the default SQL plan task application process in the public resource console. For more information about task processes, see Manage task processes.

View SQL plan tasks

Task information

6
  1. Click Task Center in the top navigation bar, and click the SQL Plan tab. In the task list on the tab, click View in the Actions column of the target task to view its details.

  2. In the Task Details panel, click the Task Information tab to view the basic task information and task settings.

    Item

    Description

    Basic task information

    You can view the task status, task ID, task type, connection, remarks, creator, and creation time.

    Task settings

    You can view the SQL content, scheduled execution period, next execution time, delimiter, query result limit, error handling method, and execution timeout period.

Execution records

In the Task Details panel, click the Execution Records tab to view information including the task ID, database, creation time, task status, and supported actions.

Operating records

In the Task Details panel, click the Operating Records tab and view information including the event operation, operation time, approval status, and supported actions.