This example will create a task that demonstrates how External memory is used in an output step to store key data generated by a task. An SQL Server database is used as the memory location.
The task runs regularly based on a schedule, it queries the database of a database system, formats the information returned as text and sends a notification via email which at the same time commits specified data to memory.
This task is made up of 4 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 of a business system to find details to map to include in the alert. |
| Format Information | Format: Format As Text | Takes the results from the 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. |
There are two different types of memory, please follow this link for the ‘Learn about’ article ‘Internal Memory’:
Tasks which write key data to a repository – Internal memory
This type of memory uses repositories within TaskCentre to store data along with a ‘Data Filter’ step.
To read about designing other tasks see:
