How to send Automatically mail to client by my website.

Question

if i have -2field in sqldb
1.Name-xyz
2.Today profit -10000
send automatically this information to client at 6 o'clock daily.
don't give me advice of window service .b/c i am unable to start my system regularly.
i want after website hosting. it should work automatically.
plz give me some help. please send me the code if possible of following any way..
1.global.asax.
2.webservice but not window services.
3. Timer event if possible on any porcess.

Steven Reid · Answer

Hi Harshal I believe that you need to contact your hosting provider for the solution.

Anupam Singh · Answer

Ok. I dont have idea how to do it on godaddy .But you should get help from their customer care.

Harshal Thakre · Answer

but i dont have my own db server i am using godaddy server... so how can i mail config on that server

Anupam Singh · Answer

Hi Try SQL mail and schedule it in SQL JOB. Just 2 steps you have to follow. 1.Read this to know how to configure sqlmail http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/ 2. Read this to send mail with data : http://sqlmag.com/t-sql/use-cursor-send-customized-email http://www.mssqltips.com/sqlservertip/2347/send-email-in-a-tabular-format-using-sql-server-database-mail/ Hope it will help.