email windows service

  • Thread starter Thread starter bonokoot
  • Start date Start date
B

bonokoot

Hello,
I'm a beginner programmer working for a small company and I've been
assigned to create a windows service in C# that will access a SQL
Server database run a stored procedure and send the results of that
stored procedure in an email every hour. I've searched through google,
msdn site, and experts exchange and having problems finding examples of
how to do something like this. Can someone point me in the right
direction to get started with this or perhaps some code examples of a
similiar program?

Thanks
 
Hello,
I'm a beginner programmer working for a small company and I've been
assigned to create a windows service in C# that will access a SQL
Server database run a stored procedure and send the results of that
stored procedure in an email every hour. I've searched through google,
msdn site, and experts exchange and having problems finding examples of
how to do something like this. Can someone point me in the right
direction to get started with this or perhaps some code examples of a
similiar program?

Thanks
Click to expand...

If you are in fact using Microsoft SQL Server, you could use the built-in
SQLMail service to acomplish this. Really all it would take is a TSQL
script running on a scheduled basis via SQLAgent. Lookup xp_sendmail and
xp_readmail in Books Online.

CVD
 
Back
Top