:Database change tasks

Task list

On the management page of the target database connection, click Task Center in the top navigation bar to open the Task Center panel. Click Database Change in the panel to display the task list.

The following table describes the columns in the task list. You can filter and sort tasks by some of the columns.

Create a database change task

1. Log on to ODC and go to the management page of the target connection. On the Task Center panel that appears, click + on the right side of Database Change, and a new data database change task panel will pop up.

2. In the Create Database Change Task panel, specify the fields described in the following table.

   Field	Description
   Connection	The name of the database connection to which the task belongs.
   Database	The database to be changed.
   SQL Content	Select SQL Entry or Upload File. SQL Entry: This is the default way to specify SQL content. You can directly write the SQL script in the editing area. Note The maximum size of the SQL statements that can be entered in the SQL window is limited to 500,000 characters. If the SQL script to be executed has more than 500,000 characters, you can directly upload the script file. 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. Note 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.
   Rollback Plan	Specify Rollback Plan. You can write an SQL script or upload a file to specify the rollback plan. For more information, see the description of SQL Content.
   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.
   Task Error Handling Method	The database change tool supports two methods to handle task errors: 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.
   Execution Timeout Value	Specify the value in the Execution Timeout Value field in hours. Default value: 48. Maximum value: 480.
   Task Description	You can enter a description of no more than 200 characters in Task Description. This field is optional.

3. Click Create. The database change task is created.

View a database change task

Task information

1. Click View in the Actions column of the row where the target task is located. The Task Details panel appears. Click the Task Information tab to view Connection, Database, SQL Content, and Rollback Content.

2. You can click Initiate Again to initiate the database change task again.

Task process

1. Click View in the Actions column of the row where the target task is located. The Task Details panel appears. Click the Task Process tab in the panel to view information on the following nodes: Initiate Task, Approval Node, Perform, and Complete.

2. You can click Initiate Again to initiate the database change task again.

Execution result

1. Click View in the Actions column of the row where the target task is located. The Task Details panel appears. Click the Result tab to view the execution success and failure records.

2. You can click Initiate Again to initiate the database change task again.

Task logs

1. Click View in the Actions column of the row where the target task is located. The Task Details panel appears. Click the Task Logs tab in the panel to view the alert logs and all logs of the task.

   Field	Description
   All Logs	Displays the INFO, ERROR, and WARN logs of the task. You can click Find, Download, or Copy to search for, download, or copy all logs.
   Alert Logs	Displays the ERROR and WARN logs of the task. When a task fails, you can view the error message in the alert logs. You can click Find, Download, or Copy to search for, download, or copy alert logs.

2. You can click Initiate Again to initiate the database change task again.