SleepMethod in VB Script

[RhythmAddict112]

Hi. Im going to try to be as concise as possible - Okay. I have a .vbs that does checks a database every X minutes (using WScript.Sleep 100, see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsMthSleep.asp

)

It gives one argument on the command line which is actually fed into the WHERE clause of the sql. If there are results, it mails them....If there are not, it does nothing, sleeps for X minutes and then repeats the process.

With me? Okay good. This all works no problem but it could be better. For one, this right now is an endless loop. Is there a way for me to gracefully exit the program once it running?

 

[PHV]

Maybe in your loop you may test the existence of a flag file (with fso) to determine if the script must continue or quit ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244