PAUSE ROUTINE LOAD

Description

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