title: Need advice to query data from sql server on every 5 seconds and send it to other app.(.NET C#)
body: <p>I have a require ment to read data from a table(SQL 2005) and send that data to other application for every 5 seconds. I am looking for the best approach to do the same.</p>
  
  <p>Right now I am planning to write a console application(.NET and C#) which will read the data from sql server 2005(QUEUE table which will be filled through different applications) and send to other application through TCP/IP(Central server). Run that console application under schedule task for every 5 seconds. I am assuming scheduled task will take care to discard new run event if task is already running(avoid to run concurrent executions).</p>
  
  <p>Does any body come accross similar situation? Please share your experience and  advice me for best approach.</p>
  
  <p>Thanks in advance for your valuable time spending for my request.</p>
  
  <p>-Por-hills-</p>