I have requirement i have to remind people that their licence is expiring in next 2 months.
While creating the profile i record their certifiate expiry date, users may be around 1000 +.
* Every week once system should get the list of users who's licence is expiring and send email to each user.
How should the server trigger that event of gathering the list and then send the email ? ( No using sql server to send emails )
While answering consider that i have to host the application on shared server or may be virtual server using some hosting plan.