Time Based SQL Insertions

Posted by Chvrsri under Sql Server on 5/4/2015 | Points: 10 | Views : 1083 | Status : [Member] [Moderator] [MVP] | Replies : 0
Hi All,

I need to send an e-mail notification to the user basing on some date and time.

Im using my front end to send the email by checking a column value (isActive) and proceeding with the notification.

Now my requirement is to have a time based trigger or a Dynamic email notification system. The Procedure should accept start date, end date and also the Subscription date. The logic here is Start and end are the two major points and subscription is the amount days we are allowing the user to access a specific resource in the application.

So now the Start date is today 5/4/5015 and end date is 10/4/2015. But the subscription time is only 2 days.

The user should receive an email on 5th that your subscription started (This can be done using Start date)

Also the user should receive that he subscription going to end on 7th so he need to receive an email basing on the subscription days.

Do i need a Time based Trigger to achieve this? Please put in your thoughts.


Radha Srikanth


(No response found.)

Login to post response