This example task runs based on a change in data in a business system, it queries the database of a business system, formats the information returned as an html email message and sends this to users derived from the information in the business system.
This task is made up of 4 steps.
|Step Named||Tool||What it does|
|Change in data detection||Microsoft SQL Server Trigger||Detects a specific change in data in a business systems database. This step outputs key pieces of information about the change and outputs them as variables.|
|Get more information||Database Query (ODBC)||Reads the database of the business system to find additional details to include in the alert. This step consumes the variables from the previous step and outputs a recordset of data.A recordset is like a table of data.|
|Format as HTML||Format as HTML||Takes the recordset results from the previous step and presents them for use in the email. The output from this step is a document set.Each row in the recordset creates a document.|
|Send Email||Send Email (SMTP)||Sends an email containing the formatted information. Each document in the document set is sent to a different email address.The email address originates in the recordset.|
To read about designing other tasks see
The Format as HTML Tool can be used to format information as one or more HTML documents in TaskCentre. The tool is dragged onto the task planner from the task browser. On the general tab of the tool the step is given a recognisable…Read More
The Microsoft SQL Server Trigger Tool can be used to start a task in TaskCentre. In the trigger step a set of conditions are specified which, when met, trigger the start of a task. How does this work? Before the Microsoft SQL Trigger Tool…Read More