Re: Scheduling Events?

Поиск
Список
Период
Сортировка
От David Durst
Тема Re: Scheduling Events?
Дата
Msg-id 34244.10.1.86.1.1043443166.squirrel@www.la-rubber.com
обсуждение исходный текст
Ответ на Re: Scheduling Events?  ("David Durst" <ddurst@larubber.com>)
Список 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 по дате отправления:

Предыдущее
От: Roberto Mello
Дата:
Сообщение: Re: CAST from VARCHAR to INT
Следующее
От: Roberto Mello
Дата:
Сообщение: Re: Getting multiple rows in plpgsql function