---
schema_version: "1"
id: 19b7c6c638d7524628e63f110911a2cf26769a102b2c58d59ce4479c554fecb2
title: Restart a Suspended SQL Query Activity
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_restart_suspended_sql_query.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_restart_suspended_sql_query.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 408fa2d3d95c71f78ffb47dd9be9a0a20f4c8668c0a16e9749af5d062e201528
description: When a SQL Query activity encounters a system error or fails 24 consecutive times, we suspend it. To find out why your query is suspended, check the action log.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Restart a Suspended SQL Query Activity

When a SQL Query activity encounters a system error or fails 24 consecutive times, we suspend it. To find out why your query is suspended, check the action log.

You can’t copy a suspended query, add it to an automation, or run it once.

1. When a query is suspended, go to that query’s action log and view the error.
2. Resolve the error, if applicable.
    
    - If the log detail shows the error, “Query activity was terminated,” don’t modify the query activity. The system error will automatically resolve and re-enable your SQL activity.
    - For all other errors, fix the problem stated in the error message.
    - If you’re not sure what caused the error, check the activity’s settings for issues or optimize the query using intermediate tables. See [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&release=264.0.0&type=5 "SQL query activities time out after 30 minutes. You can prevent timeouts and failures by optimizing your SQL query activities. If your query consistently runs longer than 10 minutes, we recommend using a different tool, such as Salesforce Customer Data Platform, to transform your data.").
3. Save your work.
    
    After you edit and save the query activity, it’s automatically restarted.