View Full Version : Triggering -

04-30-2007, 07:01 AM
Triggering -


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.

05-01-2007, 05:13 PM
Actually, the easiest way i found to automate stuff was... to cheat :)

Write a server-side script that'll do your job, write a batch file that'll open that page (write "start http://www.yoursite.com/file.asp" to notepad and save it as doMyStuffForMe.bat), and then set a Scheduled Task that runs that file.

Simple :)

05-03-2007, 12:18 PM
If you are going down that path then you may want to checkout the taskkill command

05-04-2007, 04:06 PM
What? Memory is finite??