Building a scheduled plain text email alert

This example task runs regularly based on a schedule, it queries the database of a business system, formats the information returned as a plain text email message and sends this to a fixed set of users.

Scheduled-plain-text-email-alert

This task is made up of 4 steps.

Step NamedToolWhat it does
Daily ScheduleScheduleDetermines how frequently the task is to run.

Scheduling a Task

Get the latest informationDatabase Query (ODBC)Reads the database of a business system to find the details to include in the alert.

Querying a database

Format the informationFormat as textTakes the results from the previous step and lays them out in a way that can be read.

Formatting Plain Text

Send EmailSend Email (SMTP)Sends an email containing the formatted information.

Sending an email

To read about designing other tasks see

Task Design

Related Articles

Sending an email

Before emails can be sent by TaskCentre it is necessary to configure communication with an SMTP server. The following article explains how this is achieved. Learn about: TaskCentre administration – Global configuration – Outbound SMTP connections To send an email from a task the…

Read More
BPA-8194

Formatting Plain Text

The Format as Text tool is dragged onto the task planner. The step can be given a recognisable name. Typically the step will consume a recordset. This might be information pulled back from another system by a database query. The output of the format…

Read More
BPA-8195

Querying a Database

General Tab The Database Query (ODBC) tool is dragged onto the task planner. The step can be given a recognisable name. A connection to the business systems database must be selected from the list. Setting up these connections is covered in TaskCentre Administration -…

Read More
BPA-8196

Scheduling a Task

The Schedule tool is an Event tool used to automatically trigger a task to run based on a pre-determined time. Any number of Schedule steps may be present in a task. Using the Schedule Tool The Schedule tool is dragged from the task browser…

Read More
BPA-8197