Re-run the same script

[spazman]

I have a script that just waits for an hour and then runs through some processes. The problem is that over a short period of time it consumes more memory, at start up yesterday it was using 3,064 of memory it has run the code agian every hour since and is now using 8,000 +. I am closing my connections, setting vars back to nothing and closing recordset etc. Basically what it does it query a table to see if there are any outstanding issues, is there are it email thoise people and reminds them, it opens a html templete email and fires it off. Would the memory usage be better if I just exited the script and ran it every hour using scheduler (which I never find to be reliable) Or re ran the script file it from itself.

 

[PhillipFoster]

What problems have you had running Task Scheduler?

I ran a complex suite of scripts for over a year that were fired-up by Task Scheduler (on W2k Server) at various times of the day - including a script that ran every 30 minutes) without one glitch.

The Task Scheduler route would seem the better option, rather than putting the script to sleep for an hour.