Activate reminder for event to send email notification 3 days before event
-
can anyone help me in writing stored procedure to Activate reminder for event to send email notification 3 days before event along with event description pls .i am using sqlserver2008R2.the list of events are in DB.
-
can anyone help me in writing stored procedure to Activate reminder for event to send email notification 3 days before event along with event description pls .i am using sqlserver2008R2.the list of events are in DB.
Use the datetime data type to AddDays to to the getdate() function to determine the date to check against your stored event date.
Never underestimate the power of human stupidity RAH
-
can anyone help me in writing stored procedure to Activate reminder for event to send email notification 3 days before event along with event description pls .i am using sqlserver2008R2.the list of events are in DB.
What have you tried so far? Where are you stuck and need help? Here is what is expected of enquirers: 1. TRY first what you want to do! You may find that it's not that hard. 2. Formulate what was done by you that looks like an issue/not working. Try them and tell if you face issues. For now, have a look at this to start of: Send Email from Database[^] Automatically send email every night 12.00 am[^]
Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application
-
can anyone help me in writing stored procedure to Activate reminder for event to send email notification 3 days before event along with event description pls .i am using sqlserver2008R2.the list of events are in DB.
Hi,in this you can create an job using SSMS.No need of writing stored procedure for this.