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:
This example will be using the output step Send Email (SMTP) to demonstrate the use of external memory. However, any output tool can be used as the memory feature is available to all of them. If you wish to write data to a database…Read More