run script once a day!

Results 1 to 2 of 2

Thread: run script once a day!

  1. #1
    Join Date
    Dec 1969
    Posts
    538

    Default run script once a day!

    I need to clean the database up once a day. I want this to happen automatically based on certain criteria. I know I can build and asp page, but I would have to remember to run it every day due to the nature of the data. I really want some thing that is automatic.<BR>THANKS!

  2. #2
    Nathen Grass Guest

    Default RE: run script once a day!

    I don&#039t know if you&#039re using an Access database or SQL Server database but if you&#039re using SQL Server you can create a Scheduled Task that will run a SQL statement for a time period you specify. This can be once a day at a certain time or once every hour, etc. I don&#039t know if this is what you are looking for...<BR><BR>I know there is a technique that uses the Global.asa. The article for this is found here:<BR><BR>http://www.powerasp.com/content/hintstips/schedule-global.asp<BR><BR>This technique is dependent on people hitting your site and starting a session. You can look at it and see if it&#039s what you need.

Posting Permissions

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