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