VB.net - MS SQL Webservice for Email Alerts
Budget: $30 – $250 USD
Need a webservice in VB.net running on Windows Server.
- Check in SQL Database every 5 minutes for new entries / entries with status not sent and send email to users.
- All Email related details like email ids, subject, body, attachments avaialble in database
- For each entries retrieve data from tables (2 tables - details & attachments). Once send successfully marked the timestamp in table and change status to sent.
- Tables structure will be shared later
For email sending use MailKit SDK, better option recommendation welcomed.
Deliverables:
Source Code & Documented all dependency details
Document how to install developed webservice on server
Support for deploying webservice on one server.
- Check in SQL Database every 5 minutes for new entries / entries with status not sent and send email to users.
- All Email related details like email ids, subject, body, attachments avaialble in database
- For each entries retrieve data from tables (2 tables - details & attachments). Once send successfully marked the timestamp in table and change status to sent.
- Tables structure will be shared later
For email sending use MailKit SDK, better option recommendation welcomed.
Deliverables:
Source Code & Documented all dependency details
Document how to install developed webservice on server
Support for deploying webservice on one server.