Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

How do I send email alerts to users through either a web site or SQL?

I have build a C# web site using visual studio 2008. I am using an asp.net 3.5 listview control on my frontend to display data from my SQL Server 2005 backend database. I am using both linq and sql datasources throughout my web site. I have recently built a page within my web site containing a ReportViewer control bound to an objectdatasource to display reports to my users depending on filters they set through drop down list and textbox controls on the pages frontend. What I now need to do is some how send email alerts to my users when certain dates are approching (say one month before) within my backend database. What would be the best way to achieve this functionality? SQL Mail? Some sort of web based asp.net mail control?

Any help would be appreciated.
0
Shepwedd
Asked:
Shepwedd
  • 2
1 Solution
 
RiteshShahCommented:
well after seeing your situation, I recommend you to go for SQL mail, may be set a JOB for atomization.
0
 
RiteshShahCommented:
setup email in database:
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/


After setting up email, send an email from SQL Server:
http://articles.techrepublic.com.com/5100-10878_11-6161839.html

once testing the email stored procedure whether it works, set it in JOB, you have to customize you logic based on your requirement.
http://www.ideaexcursion.com/2009/01/05/configuring-sql-server-agent-operators/


0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now