Loading

How to automate email which will send email at 5PM everyday

deva raj

Hi Everyone,

How to automate an email which will send email at 5PM everyday. The email content should be from sql server data in a table format. Is there any tool is available. Please provide reference website and code to this. Can i do it my hosting server godaddy becuase my sql server is in godaddy hosting server.

Regards,
T.N. THEAAVARAAJ
Senior Software Engineer,
Microsoft Certified Technology Specialist.
Email:[email protected]

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmikant13y ago
You can create SQL jobs which will execute stored proc and in stored proc you can write code
for sending emails

http://technet.microsoft.com/en-us/library/ms135739(v=sql.105).aspx

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
0