Once-a-day -database-search-type-thing

Results 1 to 4 of 4

Thread: Once-a-day -database-search-type-thing

  1. #1
    David Brower Guest

    Default Once-a-day -database-search-type-thing

    Greetings from rain-sodden Paisley!<BR><BR>I would like to be able to read through a database to see if there any emails should be sent on a particular day. Ideally I would want this to take place once a day. Can anyone recommend a good way of doing this? Would I need to create an Active Server Page to do this? But how would it know when to kick into action? I&#039d really appreciate any suggestions, comments or otherwise on this subject.<BR><BR>Thank you, <BR><BR>David Brower

  2. #2
    BalletChick Guest

    Default RE: Once-a-day -database-search-type-thing

    Hello David,<BR><BR>There are actually several ways to do this. You could schedule a job to be run once a day using the NT Scheduler (AT) or using some third-party scheduling program (some are free), if you have SQL Server, you could schedule a job to be run and, in fact, could do the whole job from INSIDE SQL Server! Or, you could watch the date in your Global.ASA (on session start) to see if the date has changed (store current in an application variable and compare it do datevalue(now)) and, if it has, fire up some script to do the work...

  3. #3
    David Brower Guest

    Default RE: Once-a-day -database-search-type-thing

    Thanks BalletChick, <BR><BR>I especially like the solution with the application variable. Rather nifty.<BR><BR>Thanks, <BR><BR>David

  4. #4
    BalletChick Guest

    Default RE: Once-a-day -database-search-type-thing

    Remember this, though... if you use the app var technique, then the very first visitor each day to your site may have an inordinately long wait while your script does its &#039daily&#039 thing. :) Something to think about.

Posting Permissions

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