Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

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_PRIVTablePAUSE 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;