defeated Posted February 13, 2008 Share Posted February 13, 2008 like the subject asks. I want mysql to mail me when data has expired or is just about to expire so that I can update it if needs be and somebody told me to use cronjobs. Ta much Quote Link to comment Share on other sites More sharing options...
trq Posted February 13, 2008 Share Posted February 13, 2008 Cron is a daemon used to execute scheduled commands on Linux. A cronjob, as you call it, is an entry in the crontab file telling cron at what intervals to run described commands. While you can use cron to execute php (and even pure calls to mysql), the two are in no way related. Quote Link to comment Share on other sites More sharing options...
haku Posted February 13, 2008 Share Posted February 13, 2008 Chronjobs are only triggered by time, not by events, so you couldn't set one up to mail you when data was about to expire. At least I don't think. The best you could do is create a chronjob that runs fairly frequently and searches to see if data is about to expire, and if it is, to mail you. Quote Link to comment Share on other sites More sharing options...
defeated Posted February 13, 2008 Author Share Posted February 13, 2008 That sounds about right Haku. I could set it to run daily and that would do the trick.. any pointers on where to look for how to go about setting one up? Thanks Ian. Quote Link to comment Share on other sites More sharing options...
haku Posted February 13, 2008 Share Posted February 13, 2008 My host has a chronjob wizard in the control panel. I wouldn't know how to do it manually though. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.