Loading

How to send automatic email notification to user before two

AnilKumar Murarishetti

I had two columns in my database in sql server i.e start-date and expiry-date . when user subscription going to end before two months where it needs to send automatic email to user regards your subscription going to end please renew subscription. how to write stored procudure in sql server.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajneesh Chaubey8y ago
GETDATE() will give us current date. There will be change in the query '>' should be replaced with '<' sign.
AnilKumar Murarishetti8y ago
But i need from today's date(i.e system date) to next 60 days of expiry date
Rajneesh Chaubey8y ago
This will list all employee who is going to expire in next 60 days.
CREATE PROCEDURE SP_GetEmployee
AS
BEGIN
SELECT Name, Emaild from SamplTable where DATEDIFF(day,expirydate_column, GETDATE())>=60
END
Hope it helps. Thanks!