i have an issue in email scheduling in web application
I have an issue in email scheduling in web application. I scheduled email for user with frequency of 2 days but its not working properly. It was delivered successfuly on the same day i scheduled but it is not delivered thereafter. (for ex. I scheduled email on 07/11/2019 Effective from 07/12/2019 1:30pm and Effective to 31/12/2019 then its send successfuly on 07/11/2019 but it is not delivered after 07/11/2019 )
Ramachandran MPosted Dec 9, 2019, 12:17 AM
Ronika JencyPosted Dec 9, 2019, 12:08 AM
you can try windows service if you can install it on your production server or use MSSQL schedule job to achieve this task.
For windows service:
Simulate a Windows Service using ASP.NET to run scheduled jobs - https://www.codeproject.com/Articles/12117/Simulate-a-Windows-Service-using-ASP-NET-to-run-sc
Schedule Email Through ASP.NET or Schedule Tasks Using ASP.NET -https://www.codeproject.com/Articles/49996/Schedule-Email-Through-ASP-NET-or-Schedule-Tasks-U
Scheduling Window Service Daily,Weekly,Monthly - https://www.codeproject.com/Tips/350635/Scheduling-Window-Service-Daily-Weekly-Monthly
For MSSQL Schedule job:
how to schedule a job for sql query to run daily? - https://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily
Automated Email Notifications using SQL Server Job Schedular -https://www.aspsnippets.com/articles/automated-email-notifications-using-sql-server-job-schedular.aspx