An SQL code activity executes an SQL script. The script is a JST template.
Script
The central area of the editor contains the script to be executed. This script is a JST template and can therefore be configured according to the workflow context.
Processing errors
Refer to Processing errors.
JavaScript code and Advanced JavaScript code activities execute a JavaScript script in the context of a workflow. For more on scripting, refer to the JavaScript scripts and templates section.
Starting 20.2 release, an execution delay has been added to the JavaScript code and Advanced JavaScript code activities. By default, the execution phase cannot exceed 1 hour. After this delay, the process will be aborted with an error message and the activity execution will fail.
You can change this delay in the Stop execution after field available in these activities.
To ignore this limit, you need to set the value to 0.
Script: The central area of the editor contains the script to be executed.
Process errors: Refer to Processing errors.