RESUME ROUTINE LOAD

Description

This syntax is used to restart one or all paused Routine Load jobs. The restarted job will continue consuming from the previously consumed offset.

Syntax

RESUME [ALL] ROUTINE LOAD FOR <job_name>

Required Parameters

1. <job_name>

Specifies the name of the job to restart. If ALL is specified, job_name is not required.

Optional Parameters

1. [ALL]

Optional parameter. If ALL is specified, it indicates restarting all paused routine load jobs.

Access Control Requirements

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

Privilege	Object	Notes
LOAD_PRIV	Table	RESUME ROUTINE LOAD requires LOAD privilege on the table

Notes

• Only jobs in PAUSED state can be restarted
• Restarted jobs will continue consuming data from the last consumed position
• If a job has been paused for too long, the restart may fail due to expired Kafka data

Examples

• Restart a routine load job named test1.

  RESUME ROUTINE LOAD FOR test1;

• Restart all routine load jobs.

  RESUME ALL ROUTINE LOAD;