Execute SQL Statement

Use Execute SQL Statement to execute customized business logic. For example, use Execute SQL Statement in campaigns to delete all communications for a wave item.

Do not use this workflow action unless you are an SQL expert and have tested your workflow extensively in a non-live environment. Poorly constructed or erroneous SQL could have a seriously detrimental impact on your system.


Field	Description
Type	The action to be performed.
SQL Statement	The SQL clause to be executed. You can use ## symbols to add information from the related entity. For more information, see Using the ## and # symbols. You can use multiple statements separated by semi-colons. However, you cannot declare a variable in one statement and use it in another statement.
Order	The order of the field on the screen for this workflow rule. Set the order of a field to move it to a different position on the screen and use New Line to move the field to a different line.
Show Confirmation Message	Displays a message that allows the user cancel the action before execution. You should set this to Yes. You can set up the message as a translation where Capt Family is ExecSql, Capt FamilyType is Tags, and Capt Code is the same name as the workflow action.