asked on

mySQL stored procedure... ??

I need to setup a server behaviour to send a notification to users when a mySQL stored date event has occured.
Namely: I have a start (datetime) and a duration (days) and once this event has expired (occured), I wish to fire a (php) function.

How can I setup this type of server-side behaviour? Thanx all...

--ARCglide

ASKER CERTIFIED SOLUTION

e-tsik

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ARCglide

ASKER

Thanks for your answer e-tsik... !!

The current setup is: Apache/2.0.50 (Unix) PHP/4.3.8 Server
Are there any further resources available on the net for setting up crontab within this environment??

Thanks again --ARCglide

ARCglide

ASKER

Is this a method for the Apache setup to run scheduler_script.php once per minute ??
____________________

Use "crontab -e" is the normal command to setup the cron job.

Or you can do...
echo "1 * * * * lynx -dump http://www.oneplaceonly.com/usr/local/bin/php/var/www/html/scheduler_script.php" >> /var/spool/cron/`username`

Then use "crontab -l" to check the result.
Make sure your crond is running
/sbin/service crond start
chkconfig --level 2345 cron on
------------------
REF: https://www.experts-exchange.com/questions/21252022/cron-job-setup.html

--ARCglide

e-tsik

hmm. Might work, this IS a dirty hack, though...

I would have tried just putting
1 * * * * lynx -dump http://www.oneplaceonly.com/usr/local/bin/php/var/www/html/scheduler_script.php

In your crontab

ARCglide

ASKER

E-tsik - thanks for the directional comments - I'll have a look into the use of (Apache) "crontab" and find the Apache 2.0 manual for more info.