Task workflows, containing a Script agent or a SQL agent, are used to execute system housekeeping task such as removing files or cleaning up database tables.
...
Script agent configuration
| Setting | Description |
|---|---|
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 |
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
| Setting | Description | |||||
|---|---|---|---|---|---|---|
Database | Click Browse... to select a Database profile. For further information about how to configure a Database profile, see 8.5 Database Profile. | |||||
SQL Statement | Enter a PL/SQL script or an SQL statements.
|
Data Veracity Task Agent
The Data Veracity Task Agent is explained in detail on 9.13.3 Data Veracity Task Agent