I basically have quite a major problem with a web site that I am developing
at the moment, and was wondering if anyone could maybe provide me some
guidance with this.
The problem revolves around the database part of the website. I am
developing the database using Access 2000, however I have imported the
tables and relationships into SQL server 7.
The site that I am developing allows people to advertise their Apple
Macintosh hardware for sale on the website and the potential buyers can
visit the site and get in contact with the seller.
The problem that I have is based around a requirement, whereby adverts that
are placed on the site and stored within the database, are given a 90 day
What I need to be able to do is to have some sort of way of running a
script/schedule to look at the database and perform a calculation or verify
the date field within the 'equipment database' if for example the advert is
90 days old , this would then trigger an e-mail to be sent to the seller to
remind them that their advert is still active and to either ask them to
renew it or delete it.
I need to be able set this to run at say a certain time of day, i.e late at
night, as usage of the site would be unlikely at that time.
Is this achieveable in SQL server 7? as I know this has stored procedures
and trigger capabilities aswell as SQL Mail built in. I can quite easily
use SQL server to serve my database, I'm just not very familiar with its
more complicated capabilities.
Does anyone have any ideas or guidance that you would be able to enlighten
me with, then it would be extremely appreciated!!!!!