Or you can create a new job out here in Sql Server and execute a procedure which collect information from the database itself and mail the details from db.
On Wed, Sep 15, 2010 at 6:41 PM, adithya reddy <[email protected]>wrote: > use operating system tasks to schedule your job....so that this job runs > and checks for expiry date... > > it can be debugged with visual studio just attach to process when the job > executes... > > > Thanks, > Adithya > > > On Wed, Sep 15, 2010 at 5:38 PM, stapes <[email protected]> wrote: > >> I am working on a website designed using ASP.NET C#. >> >> The user wants to do something quite basic - send out reminder emails >> after an expiry date. >> >> I am wondering how would be the best way to achieve this. Can I >> schedule something to run once a day to check for expired accounts and >> do this? >> >> Is it possible to set this up in a test environment? i.e: using Visual >> Studio 2005? > > > > > -- > With r...@rds......... > > Adithya......... > > -- Jay
