Click here to Skip to main content
15,891,905 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
I am building a windows service that will check a SQL table for any changes and if it has will export those changes and empty the table. it will do this every 15 min or so.

I am not sure how I structure it yet but I am thinking
a timer to run the query and another class to connect to the server if it has a problem running the query

To go along with this, I am also building a Winform which will be present in the windows tray icon and sort of give easy access to configuration and what not. However, I want it to display a different icon when the service is running and when it isn't (almost real-time and show notification) and show a notification when it runs into any sort of error while logging all this.

What I have tried:

I am working on the triggers but I think this is a much better way to monitor and record changes.
Posted
Updated 18-Oct-17 3:09am
Comments
Kornfeld Eliyahu Peter 15-Oct-17 5:07am    
And your question is?

1 solution

Why not use a SQL Agent job? This will run server side, has all of the scheduling options you will need and it will reduce network traffic.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900