My requirement is to write a batch program/job that sends an email every 5 minutes. It will query an sql server database.
My team is a microsoft shop so we are exposed to .Net core and SQL server.
I prefer a solution that can work in
- an on-premise infrastructure.
- or a cloud based environment such as Azure or AWS.
At this time, below are the options I am considering.
A .net core 1.1 console application that can be run as a scheduled job or hosted as an azure webjob.
Other tools that can be used to fill the plate:
docker, mailkit, logging frameworks such as serilog, nlog.