Workflow Foundation for Scheduled Process

tags:

workflow-foundation

views:

19

answers:

1

+2 Q:

Workflow Foundation for Scheduled Process

Is Workflow Foundation a good option for creating a scheduled process for a customer rebilling solution? The process needs to run daily and interact with a data layer as well as a web service. In the past, I have defaulted to using SSIS and either a Scheduled Task or SQL Server Agent job to handle the scheduling.

Any input is appreciated.

A:

On Channel 9 (endpoint.tv) there are two webcasts that address a scenario where Workflow Foundation is used for a batch job implementation.

I have used WF myself for some simple scheduled processes inside a Windows service and I must say that I'm very satisfied with the result.

Ronald Wildenberg 2010-09-11 14:38:58

Ronald, thanks for your response. I will review the links you provided. From your personal experience, do you find it overkill to use WF to create a simple process? This process would basically need to do the following: 1) Retrieve a list of clients that need to be charged, 2) iterate through the list and call a web service for each client, 3) notify each client. I feel like there should be a simple solution to such a simple process, but I always end up using an SSIS package and it feels like overkill.

XSaint32 2010-09-12 18:45:48

I definitely do not think it overkill for such a process. WF has support for error handling and parallelization and I think you can make good use of both. E.g. suppose your web service is temporarily unavailable, what to do then? And all clients can be processed in parallel.

Ronald Wildenberg 2010-09-12 20:54:45

Ronald, thanks for your feedback.

XSaint32 2010-09-13 11:37:06

ansaurus

tags:

views:

answers:

Workflow Foundation for Scheduled Process

related questions