Wait until clock time

[dickep]

I know this has been asked , but not able to find it - not good at searching this site .

I need to have an application go to a SQL database but need it to only go at a specific time each hour. Not sure how to do this and would appreciate any help/advice/examples.

Thanks

F

[PsaltyDS]

Have you written a basic script that will do ANYTHING at a specific time each hour (maybe just pop a MsgBox())? Did you want to use a script running all the time or a Scheduled Task?

Have you written a basic script to make any access at all to an SQL database? Do you know anything about ADODB, or do you want to use a command line, like OSQL.exe?

Hard to tell exactly which part you want help with. And of course we're not going to write it for you.

Well, maybe kaotkbliss will...

Edited August 30, 2010 by PsaltyDS

[kaotkbliss]

Something like?

While 1
If @min=30 Then;any hour at the 30 minute mark
_somefunc() ; go to some function to do stuff
Else
Sleep(10);pause for 10 miliseconds
EndIf
Wend

Func _somefunc()
;do whatever you need the program to do
EndFunc

[dickep]

PSaltyDS - yes, I don't expect you to write my app . I just could not figure out how to make this work using the same minute each hour. Yes, I have the ADODB stuff but just needed to trigger the time.

kaotkbliss - did not even look at @min in help . Tried datediff but, well, could not figure it out using that. Thanks for the guidance to the @min.

F

[alfa]

Hello,

I am looking for something similar.

I want the script to sleep until given time.

I stole kaosblisses code here and tired it like this. I waited till minute is 19.

While 1

If not @min = 15 then
Sleep (1000)
Endif

Wend

But i have no idea why i have written while 1 ? ANd it didnt work too

[kaotkbliss]

While 1 is an infinate loop.

What you have given says if @min is not 15 then sleep, but you don't tell it what to do if @min does =15

[Maffe811]

So if it is 15 it does nothing...

[bogQ]

you did not put anything to happend when the time is correct

While 1 (Loop) is there to keep the script alive

While 1
    If @min = 33 then
        MsgBox(0,"",@HOUR&"h "&@MIN&"m "&@SEC&"s",10)
        Do
            Sleep(10)
        Until @min <> 33
    Endif
    Sleep(10)
Wend

[alfa]

While 1 is an infinate loop.

What you have given says if @min is not 15 then sleep, but you don't tell it what to do if @min does =15

While 1

If not @min = 15 then
Sleep (1000)
Endif
Wend

Msgbox (0,"Test", @min)

How about like this ? Now did i tell it to do something if it is 15 ?

[bogQ]

No, you need to put your code "msgbox" instead "sleep(1000)" place and remove ;Not; statment in ;If then;

Edited July 5, 2011 by bogQ

[Maffe811]

Or:

While 1 
If not @min = 15 then 
Sleep (1000) 
Else
Msgbox (0,"Test", @min)
Endif
Wend

[alfa]

I probably coudnt explain what i am looking for.

I have a script that needs to be sleeping until a certain time. lets say 10:15.

Start Notepad.exe
wait untill 10:15

give txt a name and close notepad.

[bogQ]

While 1;the infinite loop to keep the script alive
    If @HOUR = 10 And @min = 15 then; if the minute counter is on 15 and H counter is on 10
        MsgBox(0,"",@HOUR&"h "&@MIN&"m "&@SEC&"s",10);msgbox to see that is working, msgbox will automaticly close after 10 seconds
        Do
            Sleep(10)
        Until @min <> 15; sleep untill minute counter is diffrent than 15, this alow you to activate your code only once on specific H time when it hit 15 minutes
    Endif
    Sleep(10);sleep 10 to reduce cpu usage
Wend

so whats wrong with this?

Edited July 5, 2011 by bogQ

[Maffe811]

Alfa, take bogQ's code and rewrite it to your needs.

We can't do everything for you!

[alfa]

Alfa, take bogQ's code and rewrite it to your needs.

We can't do everything for you!

Thats what i am trying. And i actually didnt ask you to do everything for me. I am asking a way to do something so can use it everytime i need it.

thanks bogQ for your efforts but i cant make it work. There is probably something i dont understand about this while 1 loop. Does all of the code have to be done in the loop ?

Edited July 5, 2011 by alfa

[bogQ]

while loop is a circle that keep the script looping the code all the time

loops can b

best choice for infinite loop

while $something

wend

run code 10 times

for $x = 1 to 10

next

run code untill something changes

do

something()

until $something = $something_else

If sityations where you dont have loop, your script will run your code only once and then exit

Edited July 5, 2011 by bogQ

[MvGulik]

and rewrite it to your needs.

Your sure. That's usually the part where the problems arise.

---

Oops.

[kaotkbliss]

I use something like this to create log files each day

Run("Notepad.exe C:\Log " & @YEAR & @MON & @MDAY & ".txt")
Sleep(500)
If WinExists("Notepad", "") Then
    ControlClick("Notepad", "&Yes", "[CLASS:Button;INSTANCE:1]", "LEFT", 1)
EndIf

And what it does is it tries to open the txt file but if it doesn't exist, it creates it.

You can use this to create and name your txt file in the beginning, then add text to it later.

[Maffe811]

Thats what i am trying. And i actually didnt ask you to do everything for me. I am asking a way to do something so can use it everytime i need it.

You're asking for us to write something you can use.

I can't see any effort on your part, so if you are trying post what you got.

Your sure. That's usually the part where the problems arise.

---

Oops.

What do you mean?

If he gets problems he can post the code and we can help.

But we can't help unless he does an effort for the code to work.

Edited July 5, 2011 by Maffe811

[MvGulik]

What do you mean?

If he gets problems he can post the code and we can help.

True.

But we can't help unless he does an effort for the code to work.

@general: I generally feel that the same effort applies to at least reading the doc/manual on the subjects/commands at hand.

(should also make is easier for needed party (basic newbies) to explain what it is they don't get when they do so in relation to the AutoIt documentation.)