versioned_docs/version-3.x/sql-manual/sql-statements/data-modification/load-and-export/STOP-ROUTINE-LOAD.md

---
{
    "title": "STOP ROUTINE LOAD",
    "language": "en",
    "description": "This syntax is used to stop a Routine Load job. Unlike the PAUSE command, stopped jobs cannot be restarted. If you need to import data again,"
}
---

## Description

This syntax is used to stop a Routine Load job. Unlike the PAUSE command, stopped jobs cannot be restarted. If you need to import data again, you'll need to create a new import job.

## Syntax

```sql
STOP ROUTINE LOAD FOR <job_name>;
```

## Required Parameters

**1. `<job_name>`**

> Specifies the name of the job to stop. It can be in the following formats:
>
> - `<job_name>`: Stop a job with the specified name in the current database
> - `<db_name>.<job_name>`: Stop a job with the specified name in the specified database

## Access Control Requirements

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

| Privilege  | Object | Notes                                                    |
| :--------- | :----- | :------------------------------------------------------- |
| LOAD_PRIV  | Table  | STOP ROUTINE LOAD requires LOAD permission on the table |

## Notes

- The stop operation is irreversible; stopped jobs cannot be restarted using the RESUME command
- The stop operation takes effect immediately, and running tasks will be interrupted
- It's recommended to check the job status using the SHOW ROUTINE LOAD command before stopping a job
- If you only want to temporarily pause a job, use the PAUSE command instead

## Examples

- Stop a routine load job named test1

   ```sql
   STOP ROUTINE LOAD FOR test1;
   ```

- Stop a routine load job in a specified database

   ```sql
   STOP ROUTINE LOAD FOR example_db.test1;
   ```