VeloDB Cloud
SQL Manual
Statments
Data-Manipulation-Statements
Load
PAUSE-ROUTINE-LOAD

PAUSE-ROUTINE-LOAD

Name

PAUSE ROUTINE LOAD

Description

This statement is used to pause a Routine Load job. A suspended job can be rerun with the RESUME command.

PAUSE [ALL] ROUTINE LOAD FOR job_name

Example

  1. Pause the routine import job named test1.

    PAUSE ROUTINE LOAD FOR test1;
  2. Pause all routine import jobs.

    PAUSE ALL ROUTINE LOAD;

Keywords

PAUSE, ROUTINE, LOAD

Best Practice