Automatic Updating XML from SQL server

Question

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

competent_tech · Accepted Answer · 2011-12-08 22:45:10Z

2

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.

answered Dec 8, 2011 at 22:45

competent_tech

45.1k12 gold badges96 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saif al Harthi · Accepted Answer · 2011-12-08 22:45:47Z

1

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

answered Dec 8, 2011 at 22:45

Saif al Harthi

2,9641 gold badge24 silver badges26 bronze badges

1 Comment

marc_s Over a year ago

If it needs to run every 15 minutes, using a service for that seems like overkill - just have a simple command-line tool and schedule it with Windows Task Scheduler. Debugging a command-line tool is just soo much simpler than a Windows service....

Collectives™ on Stack Overflow

Automatic Updating XML from SQL server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related