views:

163

answers:

2

I would like to set a scheduled task/cron job to update database. I planning updating the database using a php script, i.e connect to database and execute SELECT and UPDATE query. I already prepared the php script, and what should I do next?

I am (my server) is using Windows Server 2003, IIS, php and mysql.

When I google this, I got tons of results, and its confusing me. Is there any quick explanation of what should I do (step-by-step)?

(Please let me know what are the others information you need to know)

+1  A: 

nnCron

Armando Sumner
er.. Is there a free version of this kind of software? Btw, must I use this kind of software to set the scheduled task/cron job? It sounds like more and more complicated.. Oh my god!!
mysqllearner
Oh.. nnCron LITE is free, but i am still new to this. Any advice or tips before I try that on my real server?
mysqllearner
A: 

In windows schedule task, define a task to download a file(http://127.0.0.1/autotask.php) every day (or minute)

then put your code in autotask.php

amir beygi