10. Appendix 3 - Task Workflow Agents

Owned by Jenni Wallin
Last updated: May 08, 2023 by Former user (Deleted)


Task workflows are used to execute system housekeeping task such as removing files or cleaning up database tables. The following are the Task Workflow agents we have:

Script Agent

This agent runs a shell script or other executable located on the filesystem of an EC. The workflow will stop when it receives an exit code from the script. If the script returns a non-zero exit code, the workflow will abort. Output to stdout will appear in the debug output from the agent.

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.

Script agent configuration

SettingDescription

Script Name

Enter the absolute path and name of the script file or executable that will perform the task.

You may omit the path if it is not required by the shell. For instance, to remove files or directories you can simply enter rm or rmdir.

Parameters

Enter the arguments and options expected by the script. The value will be passed as-is to the shell, except for carriage return characters, which will be handled as a blank spaces.

To call the script without options parameters, leave this field blank.

SQL Agent

The SQL agent executes an SQL statement or script in the database specified by a database profile.


SQL agent configuration

SettingDescription

Database

Click Browse... to select a Database profile.

For further information about how to configure a Database profile, see 8.6 Database Profile.

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.

Data Veracity Task Agent

The Data Veracity Task Agent is explained in detail on 9.13.3 Data Veracity Task Agent.

Data Hub Task Agent

The Data Hub Task agent is explained in detail in 4.2 Data Hub Task Agent.

Next subsection:

11. Appendix 4 - Collection Strategies