SQL Task Agent(4.2)
- Jenni Wallin
The SQL Task agent is used in Task workflows, and is used for executing system housekeeping task such as removing files or cleaning up database tables. Â
The SQL Task agent executes an SQL statement or script in the database specified by a database profile.
| Setting | Description |
|---|---|
Database | Click Browse... to select a Database profile. For further information about how to configure a Database profile, see Database (3.0). |
SQL Statement | Enter a PL/SQL script or an SQL statements. Note! Group several SQL statements within a block. For a single SQL statement omit the semicolon (;) at the end. |
Warning!
It is strongly recommended that you run script task workflows on a separate EC. Running script task workflows on the same EC as other workflows may cause unpredictable errors and loss of data.
During a short time before exec() runs the actual script, fork() allocates the same amount of memory for the script as used for the EC. If the memory is not available, the EC will abort with an out of memory error and must then be restarted.