I am NEW in MVC3 and designing a web based application and kind of in learning phase. I am building a project where I need to show a list of customers in a web grid.
Now, I need to email a list of customers everyday, whose info (Name) is not updated for more than 6 months. How should I design the application? Do I need to use开发者_运维知识库 SQL Server Agent jobs for picking up the list of customers?
Any discussion or idea will be of great help. Thanks!
What you are actually seeking is how to run background tasks in asp.net mvc. There are many ways this can be done, but Jeff Atwood explained a simple version here well here when designing the badge system for stack overflow.
There are other stuff such as windows services for more intensive processes but you will have a problem when hosting on shared servers.
Your best bet is to write a windows exe or windows service. Scheduled the exe with task scheduler or maybe even Sql Agent can fire it off. Since its just once a day, I don't think a service is necessary.
精彩评论