Dear All,
I need to run particular database script every 20 minutes. So what should I be doing I am confuse between windows service and scheduled task. Which is better
Windows Service or Scheduled Task
Hot Topic
- Why ImageList can not dispose the image it contains?
- csharp code inspection
- How to get instance ID of object
- unnecessary Class files in application.
- Accessing a public item through an interface
- Using Type specific collections
- Nested Partial Classes and Designer's
- Calling a .NET Assembly DLL from within a Win32 App
- Direct draw handle
- extracting data from comma delimited string
Visual C#
- Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
- Class names not being highlighted.
- Visual Studio runs like a dog with more than 30 projects
- Hide '+' sign in DataGrid 2.0
- SetSystemDateTime
- Getting applications Paths
- C# GridView Paging from SqlServer2005
- How to understand the code
- question about ... QueryStringParameter & HttpRequest ...
- For Loop
Windows Service or Scheduled Task
progames25
Tilfried Weissenberger
Dear Gabriel,
So are you telling me to write a c# script and then put it as task scheduler to run it is it How can I write a database C# script But I guess windows service wil suit me better I guess. Please advice.
Dave Waterworth
Dear Gabriel,
I dont have that option. So I need to make a separate script will run on 20 minutes intervals. So how can I do that
StephK
I would say that which is better depends on your scenario. Meaning if you only need to do this on one machine then a scheduled task is probably the right way to go. But, if this is something that needs to be deployed to many differeny machines, then a windows service would be easier.
Hope this helps!
DavidW57
http://msdn2.microsoft.com/en-us/library/zt39148a(VS.80).aspx
smsmsm26
JoseVillalobos
I was referring to VBScript (.vbs, .wsf). Just create a ConsoleApplication that does what you need and call that .exe every 20 mins. It is perfectly possible to create a Windows Service for this but if you need to run this on a single machine and you want some kind of User Interface that shows you the progress then you can't use a Windows Service.
Agent00
Dear Gabriel,
I guess my choice wil be windos service cause I may later need to run this script on several different machines. Can you tell me where can I get a good reference to start off with my windows service application for my database script.