Skip to main content

PAUSE ROUTINE LOAD

Description

This syntax is used to pause one or all Routine Load jobs. Paused jobs can be restarted using the RESUME command.

Syntax

PAUSE [ALL] ROUTINE LOAD FOR <job_name>

Required Parameters

1. <job_name>

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

Optional Parameters

1. [ALL]

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

Access Control Requirements

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

PrivilegeObjectNotes
LOAD_PRIVTableSHOW ROUTINE LOAD requires LOAD privilege on the table

Notes

  • After a job is paused, it can be restarted using the RESUME command
  • The pause operation will not affect tasks that have already been dispatched to BE, these tasks will continue to complete

Examples

  • Pause a routine load job named test1.

    PAUSE ROUTINE LOAD FOR test1;
  • Pause all routine load jobs.

    PAUSE ALL ROUTINE LOAD;