...

View Full Version : Triggering -



phantom007
04-30-2007, 06:01 AM
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.

Spudhead
05-01-2007, 04: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 :)

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

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

:o



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum