docs/sql-manual/sql-statements/data-modification/load-and-export/RESUME-ROUTINE-LOAD.md

---
{
    "title": "RESUME ROUTINE LOAD",
    "language": "en",
    "description": "This syntax is used to restart one or all paused Routine Load jobs. The restarted job will continue consuming from the previously consumed offset."
}
---

## Description

This syntax is used to restart one or all paused Routine Load jobs. The restarted job will continue consuming from the previously consumed offset.

## Syntax

```sql
RESUME [ALL] ROUTINE LOAD FOR <job_name>
```

## Required Parameters

**1. `<job_name>`**

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

## Optional Parameters

**1. `[ALL]`**

> Optional parameter. If ALL is specified, it indicates restarting all paused routine load jobs.

## Access Control Requirements

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

| Privilege | Object | Notes |
| :-------- | :----- | :---- |
| LOAD_PRIV | Table | SHOW ROUTINE LOAD requires LOAD privilege on the table |

## Notes

- Only jobs in PAUSED state can be restarted
- Restarted jobs will continue consuming data from the last consumed position
- If a job has been paused for too long, the restart may fail due to expired Kafka data

## Examples

- Restart a routine load job named test1.

   ```sql
   RESUME ROUTINE LOAD FOR test1;
   ```

- Restart all routine load jobs.

   ```sql
   RESUME ALL ROUTINE LOAD;
   ```