OT: Hosting renewal app

  • Thread starter Thread starter MarkusJNZ
  • Start date Start date
M

MarkusJNZ

Hi all, first of all, sorry for the off topic posting but I'm am sure
there are other developers out there with the same problem.

I have a number of clients who are charged a monthly fee (Six months
in advance) for their hosting.

The monthly amount varies from client to client as does the date that
the hosting starts (e.g A clients hosting service may cost $50 per
month and be up for renewal on the 1st of January whereas another
clients hosting service may cost $80 and be up for renewal on 15
December).

Does anyone know of a (Preferably free) application which would alert
me when a clients hosting is up for renewal? I'm doing it all manually
at the moment and it's becoming a bit of a headache.
Thanks
Markus
 
Does anyone know of a (Preferably free) application which would alert
me when a clients hosting is up for renewal? I'm doing it all manually
at the moment and it's becoming a bit of a headache.
Click to expand...

I do this with what must be one of the simplest of database functions...

I have a client table in SQL Server with, among many other items of
information, hosting renewal date - every evening at 1am a scheduled job
queries this table and sends me an alert for any client whose renewal date
is between the current date and the current date plus one month...
 
Back
Top