| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | David Durst <ddurst(at)larubber(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Scheduling Events? |
| Date: | 2003-01-24 05:06:55 |
| Message-ID: | 20030124050655.GA5612@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhuvan A | 2003-01-24 05:58:18 | Re: CAST from VARCHAR to INT |
| Previous Message | Roberto Mello | 2003-01-24 03:52:41 | Re: SQL to list databases? |