This example creates a task which uses the format tool Create Workflow Job. This allows a user to have direct input in to how a task produces an outcome.
The task runs based on a change in data in a database system, it queries the database of the database system, creates a Workflow Job and sends it to a user via email.
This task is made up of 4 steps:
|Step Name||Tool||What it does|
|Customer on Hold||Event: Microsoft SQL Server Trigger||Detects a specific change in data in a business systems database. This step outputs key pieces of information by using variables.|
|Get Account Managers Email||Input: Database Query (ODBC)||Reads the database of a business system to find details to include in the alert.|
|On Hold Override||Format: Create Workflow Job||Generates a web page containing fields for completion which allows a user to interact with and affect the outcome of a task.|
|Notify Account Manager||Output: Send Email (SMTP)||Sends an email alert to a user containing a hyperlink to the Workflow Job.|
To read about designing other tasks see: