judehall
judehall

Reputation: 944

Automatic Updating XML from SQL server

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

Answers (2)

Saif al Harthi
Saif al Harthi

Reputation: 2974

build a windows service that runs the job every 15 minutes using a timer

Upvotes: 1

competent_tech
competent_tech

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

Related Questions