...
Task workflows are used to execute common activities such as test, cleanup or maintenance tasks. A number of System Tasks are pre-configured in MediationZone and can be complemented with any user-defined activity. Shell scripts and SQL scripts can be scheduled and executed through Task Workflows, using one of the following agents:
SQL Agent – Takes a database profile and an SQL statement to be executed as parameters
Script – Takes the name of the shell script and optional parameters to be passed as input to the script
List of available Task Agents:
- Data Hub – Removes old partitions from a database.
- Data Veracity – Executes repair configurations to manage faulty UDRs extracted from workflows to a database.
SQL Agent – Executes SQL statements on a database.
Script – Executes a shell script with optional parameters.
- Unit Test Runner – Runs a unit test.
Executing an SQL script using an SQL agent or Script agent in a Task workflow
...