p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Re: email notification from data in database


Message #1 by "Alan Chiu" <achiu@m...> on Thu, 6 Jun 2002 09:22:13 -0400
You can write a vbscript to grab data from the database and to send email by
using cdonts, then you can use the SQL Server Agent to set up a job to run
the vbscript.

Alan

-----Original Message-----
From: Sudhakar [mailto:sudhakar@e...]
Sent: Thursday, June 06, 2002 11:36 AM
To: ASP Databases
Subject: [asp_databases] Re: email notification from data in database


Try windows scheduling or SQL mail if your database is MSSqlserver.

Sudhakar

----- Original Message -----
From: <dfalconer@g...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, June 05, 2002 3:29 PM
Subject: [asp_databases] email notification from data in database


> I have a SQL table containing expiry dates for subscriptions. When a
> subscription approaches expiry i want to send an email to admin telling
> them. My current knowledge tells me i could do this but i would need a
> page which i ran every day. Is there anyway i can set a daily timed
> request/procedure or something which automatically once a day goes and
> generates the data and email
>
>



Message #2 by "Sudhakar" <sudhakar@e...> on Thu, 6 Jun 2002 08:35:39 -0700
Try windows scheduling or SQL mail if your database is MSSqlserver.

Sudhakar

----- Original Message -----
From: <dfalconer@g...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, June 05, 2002 3:29 PM
Subject: [asp_databases] email notification from data in database


> I have a SQL table containing expiry dates for subscriptions. When a
> subscription approaches expiry i want to send an email to admin telling
> them. My current knowledge tells me i could do this but i would need a
> page which i ran every day. Is there anyway i can set a daily timed
> request/procedure or something which automatically once a day goes and
> generates the data and email
>
>

Message #3 by dfalconer@g... on Wed, 5 Jun 2002 15:29:54
I have a SQL table containing expiry dates for subscriptions. When a 
subscription approaches expiry i want to send an email to admin telling 
them. My current knowledge tells me i could do this but i would need a 
page which i ran every day. Is there anyway i can set a daily timed 
request/procedure or something which automatically once a day goes and 
generates the data and email

  Return to Index