Skip to content

Knowledge Base

White Paper Libary

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