The PAUSE ROUTINE LOAD statement pauses a running Routine Load job and transitions it to the PAUSED state. You can resume the job by using the RESUME ROUTINE LOAD statement.
Syntax
PAUSE ROUTINE LOAD FOR job_name;
Parameters
Parameter |
Description |
|---|---|
| job_name | The name of the Routine Load job to be paused. |
Examples
Pause the Routine Load job load_job_0.
obclient> PAUSE ROUTINE LOAD FOR load_job_0;