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 NameToolWhat it does
Daily ScheduleEvent: ScheduleDetermines how frequently the task is to run.

Scheduling a Task

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

Querying a database

Data FilterGeneral: 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 InformationFormat: Format As TextTakes 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 MemoryOutput: Send Email (SMTP)Sends an email containing the formatted information.

Sending an email

Send Email And Commit To MemoryMemory feature within the output toolKey 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