Skip to main content

SHOW SYNC JOB

Description

This statement displays the status of resident data synchronization jobs in all databases.

Syntax

SHOW SYNC JOB [FROM <db_name>]

Optional Parameters

1. <db_name>

<db_name>represents the database name, which is used to specify the database from which the information of the synchronization jobs is to be shown.

Access Control Requirements

Users executing this SQL command must have at least one of the following privileges:

PrivilegeObjectNotes
ADMIN_PRIV, SELECT_PRIV, LOAD_PRIV, ALTER_PRIV, CREATE_PRIV, DROP_PRIV, SHOW_VIEW_PRIVDatabase db_nameThis operation requires at least one of the listed privileges on the target database.

Examples

  1. Display the status of all data synchronization jobs in the current database.

    SHOW SYNC JOB;
  2. Display the status of all data synchronization jobs in the test_db database.

    SHOW SYNC JOB FROM `test_db`;