Automatic batch email based on dates in database

Results 1 to 4 of 4

Thread: Automatic batch email based on dates in database

  1. #1
    Join Date
    Dec 1969
    Posts
    6

    Default Automatic batch email based on dates in database

    I have an ASP that queries the database (SQL Server) and emails all users where their last session falls within a certain date range - 30, 60, or 90 days past. The problem is that I must run this page manually. Is there anyway I can set something up to have this run automatically once every day?

  2. #2
    Join Date
    Dec 1969
    Posts
    1,175

    Default RE: Automatic batch email based on dates in databa

    Couldn&#039;t you write this into a sproc<BR>and then schedule a job to do the work.<BR><BR>It would be a whole lot faster and easier.

  3. #3
    Join Date
    Dec 1969
    Posts
    6

    Default RE: Automatic batch email based on dates in databa

    Thank you for the reply...and please forgive my ignorance, but could you elaborate on what a sproc is or point me toward some literature on the subject? Thanks!

  4. #4
    Join Date
    Dec 1969
    Posts
    1,175

    Default RE: Automatic batch email based on dates in databa

    sproc = Stored Procedure.<BR><BR>If you aren&#039;t familiar with sql server, you may want to go the asp route. It could take a bit of time to use the SQL Mail in sql server.<BR><BR>Here is a link if you wish to go that route<BR>http://www.sqlteam.com/item.asp?ItemID=5003<BR><BR>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •