Cancel/Abort Message Queue in ThinkAutomation

If you need to cancel the queue in ThinkAutomation, for example if you've accidentally caused multiple emails to be sent out in error, you can complete the following steps to interrupt the queue and stop further messages from being sent:

Stop ThinkAutomation Services

Firstly, you'll want to halt the ThinkAutomation services to prevent any further processing of messages.
This can be done by stopping the ThinkAutomation service within the Studio application or by using the Task Manager/Services to stop the necessary services.

Access the Database

ThinkAutomation utilizes a database to manage message processing. You'll need to access this database using your preferred database management tool, such as SSMS.

Execute SQL Command

Once you're connected to the ThinkAutomation database, execute the following SQL command:

This command will mark pending messages as false, effectively halting the queue.

Note: AutomationPending is a bit/boolean column. If this is set to TRUE then the server will re-add these to queue when the ThinkAutomation services are restarted.

If you also wish to remove messages from the queue entirely, you can execute the following SQL command:

Replace 'xxx' with the appropriate AutomationId.
This command will delete messages from the store, clearing the queue entirely.

Restart ThinkAutomation Services

After completing the necessary actions in the database, restart the ThinkAutomation services to resume normal operations.