Tasks which write key data to a repository – Internal memory

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.

1(1)

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.

Scheduling a Task

Retrieve Information Input: Database query (ODBC) Reads the database ofa business system to find details to include in the alert.

Querying a database

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.

Creating a Data Filter step

Format Information Format: Format As Text Takes the results from a previous step and lays them out in a way that can be read.

Formatting Plain Text

Send Email And Commit To Memory Output: Send Email (SMTP) Sends an email containing the formatted information.

Sending an email

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’:

Tasks which write key data to a database – External memory

This type of memory uses an SQL Server database as the memory location.

To read about designing other tasks see:

Task Design

Related Articles

Learn about: Writing key data to a repository using internal memory

This example will be using the output step Send Email (SMTP) to demonstrate the use of internal memory. However, any output tool can be used as the memory feature is available to all of them. Overview Memory is used to store specific data generated…

Read More
BPA-8231

Learn about: Creating a Filter Data step

Introduction The Filter Data is a General tool which is used to create a task step that takes a recordset produced by a database query and based on set rules provides a filtered output recordset for subsequent use by other Task Steps. This can…

Read More
BPA-8232