Database Workshop
Database Workshop
Document
- Documentation
Database WorkshopUser guide (RDS for MySQL)Data managementTicket listClear table ticketsManage clear table tickets
Copy page
Download PDFClear table tickets
Manage clear table tickets
Copy pageDownload PDFManage clear table tickets
This topic explains how to manage submitted tickets on the Database Workshop (DBW) console, including viewing, modifying, and approving tickets.
Prerequisites
Precautions
- View a ticket: DBW administrators can view all tickets, while DBW normal users can only view tickets they created or are assigned as approvers.
- Approve a ticket: Approvers for ticket approval are set in the approval workflow when instance security control is enabled. For detailed steps, refer to Enabling security control.
- Manually execute a ticket: If the ticket is created with the manually executed after approval option, its status will change to waiting for execution once approved. The creator must manually execute the ticket to complete the SQL statement execution.
Procedure
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, filter the target tickets as needed. You can view the following information:
- Database type is RDS for MySQL.
- Ticket type is Clear table tickets.
- On the ticket list page, you can view all ticket information, including Ticket number, Ticket title, Database instance, Database name, Source table name, Operation type, Historical data retention policy, Database type, Ticket status, Execution method, Creator, Current handler, Creation time, Last operation time, Ticket remarks, Actions, etc.
Description
- The ticket status includes Not started, Approving, Cancelled, Rejected, Wait for execution, In progress, Failed, Executed successfully, and Terminated. You can filter tickets by ticket status.
- When a ticket fails to pass pre-check, you can hover the cursor over the status of the target ticket to view the error information.
- Click the target ticket ID to view the basic information, configuration details, executed SQL statements, operation logs, and ticket workflow.
- On the ticket details page, click Approve ticket in the workflow to view the current approval progress, including approver and approval time. Click Execute ticket to view the execution progress of the ticket.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, go to the Pending my approval tab and filter the target ticket information as needed.
- Database type is RDS for MySQL.
- Ticket type is Clear table tickets.
- On the Pending my approval page, filter the target tickets as needed.
- Pass: Click Pass under the Actions column to allow the ticket to execute SQL operations.
- Refuse: Click Refuse under the Actions column to disallow the ticket to execute SQL operations.
- After the approval workflow is complete, the ticket status varies depending on the approval method:
- Automatic execution after approval: After the ticket is approved, it will automatically proceed to execution.
- Scheduled execution after approval: After the ticket is approved, its status changes to Waiting for execution. The ticket will only be executed once its scheduled start time is reached.
- Manually executed after approval: After the ticket approvalis completed, the ticket status changes to Wait for execution. The ticket creator needs to click Manual execution to execute the ticket.
If the execution method of the ticket is Manually executed after approval, the ticket creator still needs to manually execute the ticket after the ticket approval is passed.
tip
Only the ticket creator can manually execute the ticket task.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, under the All tab, filter for the target ticket as needed.
- Database type is RDS for MySQL.
- Ticket type is Clear table tickets.
- Click Manually execute in the Actions column of the target ticket, or click Manually execute on the ticket details page.
- In the Execute ticket dialog box, click OK.
- You can view the ticket execution result later.
You can terminate the checklist ticket when you no longer need to execute the checklist task.
tip
Only the ticket creator can terminate a ticket task.
- Log on to the DBW console.
- On the top menu bar, select the target region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, under the All tab, filter for the target ticket as needed.
- Database type is RDS for MySQL.
- Ticket type is Clear table tickets.
- Click Terminate in the Actions column of the target ticket.
- In the Confirm termination dialog box, click OK.
Last updated: 2026.08.04 10:53:14
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
