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’:
This type of memory uses repositories within TaskCentre to store data along with a ‘Data Filter’ step.
To read about designing other tasks see: