I would like a Windows app that will query a table in my database every X seconds where X is an integer value between 0 and 999. This app will be launched by me (it could be a window service) and will run 24/7.
The app will lookup record ID and find the column Product and Generated Link (which I want URL shortened with [login to view URL] or [login to view URL]) and create a post to my Twitter account with the information. Also, I want there to be another area where I can select an integer value between 0-99 that will skip records.
Here is a complete example
Product = Parachutes
Link = [login to view URL]
Post to my Twitter would be
Hey, Parachutes is on sale at test.com. Check it out at [login to view URL]
I also want there to be logging so that I can see the Twitter posts the app is creating. This can be shown in a status box or flat file.