Hello! I have written a php script which generates an sql file containing all tables in my database. What i want to do is execute this script daily or every n days. I have read about cron but i am actually using Windows. How can i automate the execution of the script on the server? Thanks!
+2
A:
add a scheduled task to request the url. either using a batch file or a script file (WSH).
http://blog.netnerds.net/2007/01/vbscript-download-and-save-a-binary-file/
this script will allow you to download binary data from a web source. Modify it to work for you particular case. This vbs file can either be run directly or executed from within a script. Alternately you do not have to save the file using the script, you can just output the contents (WScript.Echo objXMLHTTP.ResponseBody) and utilize the CMD out to file argument:
cscript download.vbs > logfile.log
save that bad boy in a .bat file somewhere useful and call it in the scheduler: http://lifehacker.com/153089/hack-attack-using-windows-scheduled-tasks
Gabriel
2010-05-04 09:07:58
can you send me some links please?
chupinette
2010-05-04 09:09:03
@Gabriel:Thanks for the links
chupinette
2010-05-04 09:24:44
+2
A:
You'll need to add a scheduled task to call the URL.
First of all, read up here: MS KB - this is for Windows XP.
Second, you'll need some way to call the URL - i'd recommend using something like wget - this way you can call the URL and save the output to a file, so you can see what the debug output is. You can get hold of wget on this page.
Final step is, as Gabriel says, write a batch file to tie all this up, then away you go.
e: wget is pretty simple to use, but if you have any issues, leave a comment and I'll help out.
ee: thinking about it, you don't even really need a batch file, and could just call wget directly..
danp
2010-05-04 09:17:02
@danp : Hello!Thanks a lot for the links. I have a question, concerning the first link, if my application is on the running on a server how do i Add a Schedule Task?
chupinette
2010-05-04 09:24:09
There are two things here - the first is the server, and the second is where you call the script on the server *from*. Where you call the script from can be anywhere, it can be on the same machine, or on a different remote machine. Imagine you have the script on www.mybox.com/dailyscript.php - on your office or home machine you add a scheduled task which calls that script using wget (or whatever) and basically, it should "Just Work".
danp
2010-05-04 09:40:53
when adding a schedule task, i need to specify the action that will occur and its details. I have selected: Start a program and http://localhost/final/myscript.php.Is that correct?
chupinette
2010-05-05 11:28:42
it may work, but if you change it to "wget localhost/final/myscript.php" then for sure it'll be fine. Put a target for the file it gets and that should be done.
danp
2010-05-05 13:26:23
i have changed it to wget but it does not seem to work. Can you help me please?
chupinette
2010-05-05 14:40:26
C:\Program files\GnuWin32\bin>wgetI get : SYSTEM_WGETRC = c:progra....syswgetrc = C:\Program Files..wget: missing URL
chupinette
2010-05-05 15:46:28
Yes it works! myscript.php is supposed to send a mail. The mail successfully sent. So now that it works from command line, can you guide me how to solve the problem?
chupinette
2010-05-05 16:20:55
ive found my mistake! Thanks a lot danp! i should have written "C:\Program Files\GnuWin32\bin\wget.exe" http://localhost/final/myscript.php
chupinette
2010-05-05 16:24:24
no probs :) I thought that what was going on was that the path to wget was not in the "PATH ... " environment variable, so it couldn't be found... If you want to add it in, just add the directory where wget is to your environment, but be careful, as it's pretty easy to break stuff. More info here: http://support.microsoft.com/kb/310519
danp
2010-05-05 18:04:13