Re: Scheduling Events?

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!