How to send automatic email notification to user before two

Question

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.