This example will create a task that demonstrates how Internal memory is used in an output step to store key data generated by a task. A repository within TaskCentre is used as the memory location.
The task runs regularly based on a schedule, it queries the database of a database system and a data filter defines what information from a recordset is used. The information returned is formatted as text and a notification is sent via email which at the same time commits specified data to memory.
The task is made up of 5 steps:
|Step Name||Tool||What it does|
|Daily Schedule||Event: Schedule||Determines how frequently the task is to run.|
|Retrieve Information||Input: Database query (ODBC)||Reads the database ofa business system to find details to include in the alert.|
|Data Filter||General: Database Query (ODBC)||Takes a recordset produced by a database query and based on set rules provides a filtered recordset for subsequent use by other task steps.|
|Format Information||Format: Format As Text||Takes the results from a previous step and lays them out in a way that can be read.|
|Send Email And Commit To Memory||Output: Send Email (SMTP)||Sends an email containing the formatted information.|
|Send Email And Commit To Memory||Memory feature within the output tool||Key information is saved to memory.|
Writing key data to a repository using internal memory
There are two different types of memory, please follow the below link for the ‘Learn about’ article ‘External Memory’:
This type of memory uses an SQL Server database as the memory location.
To read about designing other tasks see: