> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/sql-commands/jobs/pause-resume-job.md).

# PAUSE / RESUME JOB

You can pause and later resume a job using the syntax below, or directly from the **Jobs** page in the Upsolver user interface, by right-clicking on the individual job menu. 

Reasons for pausing a job could be:

* **Maintenance** - Performing maintenance or upgrades of the source or target database. 
* **Data Recovery** - If errors occur during data processing, you may need to pause the ETL job to investigate and correct the issues. This can help avoid propagating errors into downstream systems. 
* **Testing** - Temporarily halt data ingestion to verify/compare data in different scenarios. 
* **Reduce Load** - you may want to reduce the current load on the source or target system.

While your job is paused, you can make alterations to the job options or add expectations. You can only alter options that are mutable. Please see [ALTER JOB](/content/reference-1/sql-commands/jobs/alter-job.md) for further instructions.  

{% hint style="info" %}
**Note**

Pause / Resume job is not supported by ingestion or transformation jobs that write to data lake tables. 
{% endhint %}

## Syntax

### Pause Write

SQL syntax to pause a job in Upsolver.

```sql
ALTER JOB <job_name> PAUSE WRITE [IGNORE_WARNINGS = (...)];
```

### Resume Write

SQL syntax to resume a job in Upsolver.

```sql
ALTER JOB <job_name> RESUME WRITE;
```

## Examples

The following statement pauses the **ingest\_web\_orders\_to\_snowflake** job:

```sql
// Pause the job execution
ALTER JOB ingest_web_orders_to_snowflake PAUSE WRITE;
```

Furthermore, you can instruct Upsolver to and include the warnings you want to ignore:

```sql
// Pause the job execution and ignore warnings
ALTER JOB ingest_web_orders_to_snowflake PAUSE WRITE 
     SKIP_VALIDATIONS = ('DATA_RETENTION');
```

To resume the **ingest\_web\_orders\_to\_snowflake** job, run the following statement:

```sql
// Resume the job execution
ALTER JOB ingest_web_orders_to_snowflake RESUME WRITE;
```

## Pause / resume a job using the UI

### Pause Write

You can also pause or resume a job from the **Jobs** page in the UI. Hover your mouse over the **three-dots menu** on the job you want to pause:&#x20;

<figure><img src="/files/TnW0Yf0B1P815KkY4vOS" alt=""><figcaption><p>Pause or resume a job from the <strong>Jobs</strong> page.</p></figcaption></figure>

From the job menu, select **Pause Load to Target**:

<figure><img src="https://lh7-us.googleusercontent.com/Iz7lY7CIN0p8OUY2qO0sugBfi3XvdcXIy-VcQRNFXz74RPhmlXkRqd3s4hCsd4Fc5O1MI_PmKA2MQkJmvHD50sG4zM8S7znP45IKtQEaLNfLsimrE8W9g91XzzCHOs3p0dtSSET9yRSeL3JtYkJPzLM" alt=""><figcaption><p>Select <strong>Pause Load to Target</strong> from the Job menu.</p></figcaption></figure>

You will be presented with a modal window asking you to confirm if you want to pause the job:

<figure><img src="https://lh7-us.googleusercontent.com/URB1rg8UMK0j20iqm3B-kXnxADUsJdDvE5IKAZPcVv_ZoWE34XXwTjLqydfT7sp3mwwYJOQ9vTGgD9zE8EZRiyFPeEduDKK1TDjdq7OULOKhJhXs_qOPHrza2mo1JwYWN30gUEThWTDpIrS8XgAaRDE" alt=""><figcaption><p>Select <strong>Pause Load to Target</strong> to confirm the operation.</p></figcaption></figure>

The window also presents you with the SQL syntax for pausing the job, should you wish to copy and paste this into a worksheet to run the statement manually. Note that if you manually run the SQL statement, there is no pre-check and the command will execute immediately.&#x20;

Click **Pause Load to Target** to continue, and the job status will refresh and display **Writing Paused**. Alternatively, click **Cancel** to exit without pausing the job.&#x20;

### Resume Write

When you are ready to start the job, click on the **three-dots menu**, and select **Resume Load to Target**:

<figure><img src="/files/WkSLQ96VCvHfdr39OUmQ" alt=""><figcaption><p>Select Resume Load to Target from the Job menu</p></figcaption></figure>

The job will begin loading data immediately and the job status will display **Running**.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://upsolver.gitbook.io/content/reference-1/sql-commands/jobs/pause-resume-job.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.