Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-03-15 : 08:55:32
|
| Hi,It basically uploads the data from inside the files into sql server 2005 and then moves files around on the network.At present I have this function inside a button in a .net 2.0 win application.This functionality will have to be scheduled to run either every few minutes or as of when there are files on the network (To be decided later).I am thinking that may be it is best to create a windows service for this task. What do you think?I am also using sql server 2005.Do you think I should use windows service in .net 2.0? #Is there a functionality in sql server 2005 for this kind of functionality?Thanks |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2007-03-15 : 09:30:54
|
| There is a scheduler in SQL server, called the SQL Server Agent. You can use that to schedule your task. If you want to make your own windows service you will be "reinventing the wheel" a little bit, and it will be quite a big job to make a robust scheduler with error handling/logging etc.The only problem I can see here is that you are moving files across the network. This will require that the windows user running the SQL Server Agent service has to be a domain account rather than a local one. |
 |
|
|
|
|
|
.net scheduled task