would be much easier to answer this question if we knew what OS is running MYSQL. I use linux and use cron for most MYSQL stuff. My pc is NT and for that I use AT. for win2k Professional, I believe there is a graphical version of AT. bill
-----Original Message----- From: Christian Sage [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 07, 2001 3:23 PM To: [EMAIL PROTECTED] Cc: 'Mysql List'; [EMAIL PROTECTED]; Bill Adams Subject: AW: JOBS in mysql Hi, > Harpreet wrote: > > > I have run JOBs in sql server and was wondering if we have ne thign similar > > in mysql or use PHP to write a script that would automatically run every 10 > > minutes. > > Unix has cron: 'man crontab' > > I think Win2k has it included. Otherwise you will have to get an add-on > service. AFAIK there is only 'at' and not 'cron' to be had from the command line. You could also achieve the desired result using 'at', I guess, but the action list would become a pain to maintain, and it would also be a serious abuse of the utility (IMHO, that is). Your best bet is probably to hunt around for a freeware utility. There's bound to be something somewhere on the net. Cheers, Christian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]