On Thursday January 23 2003 5:16, David Durst wrote:
Is there anyway to schedule DB Events based on time?
If you're using one of the unices (linux, etc.), how about...
crontab + perl + DBI + DBD::Pg?
or
crontab + bash/sh + psql + pl/pgsql?
---(end of
Yes! cron
Here is the basic problem w/ using CRON in an accounting situation.
I can't be sure that cron will always be up when the DB is up,
so lets say crond goes down for some random reason (User, System
error,
Etc..)
And outside adjustment is made to lets say the equipment account
On Fri, Jan 24, 2003 at 00:45:38 -0800,
David Durst [EMAIL PROTECTED] wrote:
I can't be sure that cron will always be up when the DB is up,
so lets say crond goes down for some random reason (User, System error,
Etc..)
One option would be to run the cron job fairly often and have it check
Achilleus Mantzios [EMAIL PROTECTED] writes:
On Fri, 24 Jan 2003, David Durst wrote:
Here is the basic problem w/ using CRON in an accounting situation.
I can't be sure that cron will always be up when the DB is up,
so lets say crond goes down for some random reason (User, System error,
.
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Achilleus Mantzios [EMAIL PROTECTED]
Cc: David Durst [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 24, 2003 10:32 AM
Subject: Re: [SQL] Scheduling Events?
Achilleus Mantzios [EMAIL PROTECTED] writes:
On Fri, 24 Jan 2003
Hi
I would agree that cron is probably the best solution.
You could have cron perform a query that has a trigger and performs all the
tasks you need done. As well you could create a trigger on other queries that
would perform the other things as well, but make sure it isn't a heavily used
here is a possible NON-Cron solution that a friend of mine came up w/
1) Create a table w/ scheduled events and Account Ids attached to them.
2) Create a table w/ temporal event execution timestamps.
3) On journal entry check to see if there any schedule events for the Account
4) Check timestamp
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
On Thu, 23 Jan 2003, David Durst wrote:
Is there anyway to schedule DB Events based on time?
Yes! cron
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.
---(end of
