Triggering -

Hello,

Need help :)

Herez the scenario:

I am maintaining a list of members of my site in a database. All members have an expiry date column in a table which is in mm/dd/yyyy format. I want that every members should be emailed on the day of their expiry automatically. I dnt wanna search for members and then mail then manually or if I m out on vacation it should do the work for me.

I have heard this can be done using triggers, but not sure how to use it.

Can u help me? also is there any other way apart from using triggers?


PS: Corn Jobs are not enabled in my webhost just in case if you are going to suggest me that. :)

Thanx in advance.



-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Hi,

Are you using SQL Server Database? If yes, here is the answer…

Write a “Stored Procedure” which queries the table and fetches the list of members whose account has expired today. Use cursor to loop through records and send out emails from SQL Server Database by creating object to the mail component. Now use SQL Job Scheduler to schedule and run the Stored Procedure once a day.

I hope this solves your problem.


Ragards,
Akash - The Sky