Re: Scheduling Events? - Mailing list pgsql-sql

From David Durst
Subject Re: Scheduling Events?
Date
Msg-id 34244.10.1.86.1.1043443166.squirrel@www.la-rubber.com
Whole thread Raw
In response to Re: Scheduling Events?  ("David Durst" <ddurst@larubber.com>)
List pgsql-sql
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 table for last execution  If Last execution is out of range    force execution  Else    continue as
normal

This is passive but it should allow for data integrity w/ out the need of
a external system.







pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: CAST from VARCHAR to INT
Next
From: Roberto Mello
Date:
Subject: Re: Getting multiple rows in plpgsql function