Scheduling tasks

[1sabine8]

Hi, I need to get data from SQL and write it on an application using the application's web services. I need this to be scheduled. What's best to do? Write a Windows Service and schedule it or write a console application and schedule it in the Task Scheduler? Thanks in advance

[Lost User]

I'd go for the console-application, read the records in a DataTable and pump them one by one to the WebService of the application that you're going to export to. That's easily scheduled through the Windows Task Scheduler, and easy to understand (therefore, easy to maintain) You can run a console-application as a service and effectively delay this decision. There are some freeware-tools out and about that can help in this regard. --edit-- Question was about a Windows-service, not webservice..

I are troll :)

modified on Wednesday, March 4, 2009 3:39 AM

[Dave Kreskowiak]

Depending on the frequency you need to run this you would do either. If you have to run this query many times a day, then a service might be in order. If it's just one or two times a day, then a console app launched through the Task Scheduler would be a better choice.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008