View the configurations of the scheduled partition balancing task

The system has a built-in scheduled partition balancing task SCHEDULED_TRIGGER_PARTITION_BALANCE. You can view the parameter configurations of the scheduled partition balancing task as needed in a user tenant.

Procedure

1. Log in to a MySQL tenant or an Oracle tenant of the cluster as the tenant administrator.

   Here is an example of the connection command. Replace the parameters with those in your actual environment.

   obclient -h10.xx.xx.xx -P2883 -uroot@mysql_tenant#obdemo -p***** -A
   

2. Execute the following statement to view the configurations of the scheduled partition balancing task in the current tenant.

   The DBA_SCHEDULER_JOBS view displays the information about all scheduled tasks in the current tenant.

   MySQL-compatible mode

   Oracle-compatible mode

   The statement is as follows:

   obclient [oceanbase]> SELECT JOB_NAME, JOB_ACTION, START_DATE, REPEAT_INTERVAL, ENABLED, NEXT_RUN_DATE,MAX_RUN_DURATION, COMMENTS FROM oceanbase.DBA_SCHEDULER_JOBS WHERE job_name = 'SCHEDULED_TRIGGER_PARTITION_BALANCE'\G
   

   The statement is as follows:

   obclient [SYS]> SELECT JOB_NAME, JOB_ACTION, START_DATE, REPEAT_INTERVAL, ENABLED, NEXT_RUN_DATE,MAX_RUN_DURATION, COMMENTS FROM SYS.DBA_SCHEDULER_JOBS WHERE job_name = 'SCHEDULED_TRIGGER_PARTITION_BALANCE'\G
   

   The query result is as follows:

   *************************** 1. row ***************************
            JOB_NAME: SCHEDULED_TRIGGER_PARTITION_BALANCE
          JOB_ACTION: DBMS_BALANCE.TRIGGER_PARTITION_BALANCE()
          START_DATE: 2024-06-14 00:00:00.000000
     REPEAT_INTERVAL: FREQ=DAILY; INTERVAL=1
             ENABLED: 1
       NEXT_RUN_DATE: 2024-06-15 00:00:00.000000
    MAX_RUN_DURATION: 7200
            COMMENTS: used to auto trigger partition balance
   1 row in set
   

   In the query result:

   • JOB_NAME: the name of the scheduled task. In this example, SCHEDULED_TRIGGER_PARTITION_BALANCE is the name of the scheduled partition balancing task.
   • JOB_ACTION: the content executed by the scheduled partition balancing task.
   • START_DATE: the trigger time of the scheduled partition balancing task. The default value is 00:00 every day.
   • REPEAT_INTERVAL: the trigger interval and frequency of the scheduled partition balancing task. The default value is once a day.
   • ENABLED: indicates whether the scheduled partition balancing task is enabled. 1 indicates that the task is enabled, and 0 indicates that the task is disabled. The default value is 1.
   • NEXT_RUN_DATE: the time when the scheduled partition balancing task is triggered next time.
   • MAX_RUN_DURATION: the timeout period for executing JOB_ACTION. The default value is 7200, in seconds.

   For more information about the fields in the DBA_SCHEDULER_JOBS view, see DBA_SCHEDULER_JOBS.

References

Configure a scheduled partition balancing task