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.
This task is made up of 4 steps.
|Step Named||Tool||What it does|
|Daily Schedule||Schedule||Determines how frequently the task is to run.|
|Get the latest information||Database Query (ODBC)||Reads the database of a business system to find the details to include in the alert.|
|Format the information||Format as text||Takes the results from the previous step and lays them out in a way that can be read.|
|Send Email||Send Email (SMTP)||Sends an email containing the formatted information.|
To read about designing other tasks see
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
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
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