This topic describes how to view the detailed execution information about a plan.
Applicability
This topic applies only to OceanBase Cloud Platform (OCP) Enterprise Edition. OCP Community Edition does not support this feature.
Prerequisites
You have been granted the ADMIN role.
Execute a plan
For a plan for which the automatic execution is disabled, you can perform the following steps to manually execute it when the corresponding event occurs:
Log on to the OCP console.
In the left-side navigation pane, choose O&M Management > Plan Management. The Plans tab automatically appears.
Find the target plan and click Execute in the Actions column.
In the panel that appears, click OK.
Notice
View the operations to be performed by the plan to avoid causing other issues.
View a plan execution task
You can perform the following steps to view the execution details of a plan that is in the Executing, Failed, or Completed state:
Log on to the OCP console.
In the left-side navigation pane, choose O&M Management > Plan Management. The Plans tab automatically appears.
Find the target plan and click View Task in the Actions column.
The alert details page corresponding to the plan event appears, where you can view the execution information about the plan. For more information, see Execute the alert clearance plan.
View SQL information
For an SQL-related plan, you can perform the following steps to view the SQL information about the corresponding event if the plan is in the Pending, Executing, Failed, or Completed state.
Log on to the OCP console.
In the left-side navigation pane, choose O&M Management > Plan Management. The Plans tab automatically appears.
Find the target plan and click View SQL in the Actions column.
The SQL details page appears. For more information, see View details of an SQL statement.