you can run a cron job calling your script "sandesh.s_magdum" <sandesh.s_magdum@xxxxxxxxxxx> wrote: I need to set say `status` field of a mysql table to 'N' for suppose 8 hours. After completing 8 hours the `status` should be set to 'Y' again. Is there any technique like mysql triggers or mysql events with which I can achieve my requirement? Thank you in advance! Have a great day ahead. Regards Sandesh. Veritas Liberabit Vos --------------------------------- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed]