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!