Saroj13
asked on
How to automatically generate a reminder email to the User on the 14th calendar day in Sql Server 2008?
Hi
I have a webpage through with NewsFeedback is submitted.
In the table, I have feedbackdate_submitted, feedbackdate_closed, userid, useremail, information in the database.
I need to send a reminder email automatically on the 14th calendar day after the first time feedback is submitted. If feedback submitted on May1, then reminder email will generate on May14 to the user. After then every 10th day, email reminder wil send to user as long as the feedback is not closed.
How to do that in sql server job?
Thanks
I have a webpage through with NewsFeedback is submitted.
In the table, I have feedbackdate_submitted, feedbackdate_closed, userid, useremail, information in the database.
I need to send a reminder email automatically on the 14th calendar day after the first time feedback is submitted. If feedback submitted on May1, then reminder email will generate on May14 to the user. After then every 10th day, email reminder wil send to user as long as the feedback is not closed.
How to do that in sql server job?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
look Here
https://msdn.microsoft.com/en-us/library/ms190307.aspx
Create a job that calls dbo.sp_send_dbmail
pass it parameters needed