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?