Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 04E3947667F for ; Fri, 24 Jan 2003 00:59:52 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id CFECC47694C for ; Fri, 24 Jan 2003 00:01:31 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18bw3M-0001TC-00; Thu, 23 Jan 2003 22:06:56 -0700 Date: Thu, 23 Jan 2003 22:06:55 -0700 From: Roberto Mello To: David Durst Cc: pgsql-sql@postgresql.org Subject: Re: Scheduling Events? Message-ID: <20030124050655.GA5612@cc.usu.edu> References: <39409.216.86.192.34.1043367412.squirrel@www.la-rubber.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <39409.216.86.192.34.1043367412.squirrel@www.la-rubber.com> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/382 X-Sequence-Number: 11247 On Thu, Jan 23, 2003 at 04:16:52PM -0800, David Durst wrote: > Is there anyway to schedule DB Events based on time? > So lets say I had a table w/ depreciation schedules in it, > I would like the DB to apply the formula and make the entries on the END > of every month. 1) Write a script that invokes psql with the appropriate queries 2) Schedule a cron job to the end of the month Each tool doing its own small task well done. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + Junior, quit playing with your floppy!