Horton

Re: [SQL] a script that queries database periodically

Roberto Mello <rmello@cc.usu.edu>

View thread View on postgr.es
From: Roberto Mello <rmello@cc.usu.edu>
To: "Poul L. Christiansen" <poulc@cs.auc.dk>
Cc: Bernie Huang <bernie.huang@ec.gc.ca>, PHP_DB <php-db@lists.php.net>, PHP_General <php-general@lists.php.net>, PGSQL-SQL <pgsql-sql@postgresql.org>, PGSQL-GENERAL <pgsql-general@postgresql.org>
Date: 2000-11-27T21:56:59Z
Lists: pgsql-general, pgsql-sql 
"Poul L. Christiansen" wrote:

> > I was thinking of writing up a PHP script and put into crontab, which is
> > somehow easier than a shell script, but PHP is an apache module, so I
> > cannot execute PHP under crontab (it has to be executed in a browser
> > right?).  I guess a shell script is necessary.  So, is it possible to
> > call 'psql' and returning its query result and I can use sendmail to
> > email the result? Any other idea?

	PHP does not have a scheduling facility? AOLserver (the web/application
server that powers AOL) has had such facility (and many many others for
db-backed websites) since 1995. ns_schedule_proc.
	http://www.aolserver.com

	-Roberto
-- 
Computer Science			Utah State University
Space Dynamics Laboratory		Web Developer
USU Free Software & GNU/Linux Club 	http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto