Hello,
Problem statement ::
1) I have a birthday database which stores name s and date of birth of the persons.
2) Whenever sysdate and date of birth are equal then i want the sqls erver to send a mail/alert to my mail id saying that to day is birthday of so and so person.
3) I ma working on YUKON.
4) Please let me know how to accomplish this task?
Thanks&Regards,
Sreekanth Ammisetty
ask_sreekanth@.hotmail.com
Hi Sreekanth.
You want to make use of Database Mail for this type of thing. See the following topic in SQL Server 2005 Books Online for more information, and repost any specific questions you may have after that:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/14cbf88f-d9d1-41a5-994e-532e2973ac9e.htm
|||Hi Chad,
The link that you have provided is not working, however I ahve got solution for this to some extent. I am using "EXEC msdb.dbo.sp_send_dbmail ....." command to send the mails, But the problem I am getting is that SMTP service is not there in my desktop, I tried by installing the same, But still i could able to achieve the desired bahaviour, bcoz it is giving error related to SMTP.
The following is the error I am getting "A severe error occurred on the current command. The results, if any, should be discarded."
Please let me know the solution for this.
|||May try XPSMTP from http://www.sqldev.net/xp/xpsmtp.htm here.
No comments:
Post a Comment