Reputation: 944
I need to retrieve information from a SQL server and insert into a XML doc. The problem is not retrieving the information itself, but I want it to be done automatically e.g. 4 times per hour.
What can I use to automate this process? I'm using C# .NET
Upvotes: 0
Views: 60
Reputation: 2974
build a windows service that runs the job every 15 minutes using a timer
Upvotes: 1
Reputation: 44921
A few options:
1) Schedule a job to execute every 15 minutes in SQL Server
2) Schedule a job to run every 15 minutes using windows task scheduler
3) Write a small service that executes your logic every 15 minutes.
Upvotes: 2