<div>
I discovered how to send a email <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech</a><br />
<br />
Still looking for the answer to set a trigger to shoot off each day at a certain time.
</div>


I discovered how to send a email http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech [http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech]

Still looking for the answer to set a trigger to shoot off each day at a certain time.

<div>
To set the dates/times etc, one has to set the SQL Agent - Jobs. &nbsp;Works great
</div>


To set the dates/times etc, one has to set the SQL Agent - Jobs.  Works great

<div>
<div class="content wysiwyg-content">
I am using SQL Server v8. &nbsp;In my web application and in the following scenario, is my solution possible? &nbsp;If so, how would I do it?<br />
<br />
A user wants to be notified 2 days before their membership expires. &nbsp;I am gathering that I could fire a trigger at 1:00 am to search the DB, retrieve the users emails from the DB, and send an email through the DB. &nbsp;I am assuming that SQL Server could fire the trigger at 1:00, run the query, and send a email. &nbsp;Is this possible in SQL Server? &nbsp;<br />
<br />
I know the email part is possible in Oracle and I believe that Oracle can also fire a trigger at a certain time as well, but is it possible in SQL Server? &nbsp;Is so, how?<br />
<br />
I am not a DB wizard by any means, so have your answers fairly descriptive.<br />
<br />

</div>
</div>


I am using SQL Server v8.  In my web application and in the following scenario, is my solution possible?  If so, how would I do it?

A user wants to be notified 2 days before their membership expires.  I am gathering that I could fire a trigger at 1:00 am to search the DB, retrieve the users emails from the DB, and send an email through the DB.  I am assuming that SQL Server could fire the trigger at 1:00, run the query, and send a email.  Is this possible in SQL Server?  

I know the email part is possible in Oracle and I believe that Oracle can also fire a trigger at a certain time as well, but is it possible in SQL Server?  Is so, how?

I am not a DB wizard by any means, so have your answers fairly descriptive.



Fire trigger at certain time

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.