I have a tasks table in my db. I want to read data from this table and run tasks. Which one is better whether to have it as windows service or a console application running. The server on which this will be run will not be shutdown
You most likely want to use a windows service.
net start <scriptname>)
Quoted from here: What is the benefit of developing the application as a windows service?