Link to home
Start Free TrialLog in
Avatar of Saroj13
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
Avatar of Leo Torres
Leo Torres
Flag of United States of America image

You may need to enable procedure use in sql.

look Here
https://msdn.microsoft.com/en-us/library/ms190307.aspx

Create a job that calls dbo.sp_send_dbmail
pass it parameters needed
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial