I need a .NET C# Windows Service, which would run on a server and send an email with dynamic parameters (Name of reviever and etc') each ten minutes (or other interval of time).
The service would send emails by a Stored Procedure (Which is already ready on a ready SQL2005 Database)? which would return email addresses and more fields to include in the mail. After sending each email, the service would run another Query which I'll supply on the remote database.
The database is ready and would sit on the same server, and also the Stored Procedures which return the email addresses to send each time are ready. I only need the service, ready to be installed, which would send the emails each amount of time.
This is a small task, All the service should do is Get a DataTable with Email addresses and names and send an Email (Which's format is already ready) to these Addresses and each time it successfully sends an email, it should run another Procedure on this Row (To update that the email was sent).
The service should run on the Windows Server Services and could be paused/stopped/restarted. Also I should be able to set the interval and the SMTP settings on the configurations window of this service.