is it possible to call a db procedure on particular time???

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

is it possible to call a db procedure on particular time???

Post by raghavan20 »

I am wondering is it possible to call a procedure at specific time in a day. If more than one solution is available, please let me know all of them. Thanks for your support.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

If you're on a *nix server then you'll be wanting a cron job. In Windows there's task scheduler.

Mac
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

I have found from the mysql docs that we can create event but is supported only from 5.1
Post Reply