Zulu
Posts: 33
|
| Posted: 09/01/2004, 4:10 PM |
|
Is it possible to run a mysql proc automatically at a specific time.
Say inserting some records from one table to another at 12:00:01 am everyday.
|
 |
 |
Karsten
Posts: 57
|
| Posted: 09/01/2004, 7:46 PM |
|
Hi Zulu
what server do you use, what database
if you run linux you can use a cronjob calling cron.php for example
in the called cron.php you then write code as you want, for example :
inserting some records from one table to another at 12:00:01 am everyday.
_________________
If one gives up, he told himself he failed. |
|
|
|
Zulu
Posts: 33
|
| Posted: 09/02/2004, 8:44 AM |
|
I'm working on a Windows 2k and XP/MySQL/PHP environment. Is there any cronjob in these env?
|
|
|
|
Karsten
Posts: 57
|
| Posted: 09/03/2004, 1:06 AM |
|
Yes you can, w2k has build in schedule features
look in your redmond help file 
things you have top do:
1. write a .php file with the commands/programm you want to run on a timed base
2. add the .php to the windows schedule manager
there are other ways it could be done, but as you sound the above will be challenge enough for you 
_________________
If one gives up, he told himself he failed. |
|
|
|
Zulu
Posts: 33
|
| Posted: 09/03/2004, 8:49 AM |
|
Thanks, but I found a better solution. Cron for Windows. Thanks anyway.
|
|
|
|
|
