Re: Scheduled jobs

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Scheduled jobs
Дата
Msg-id Pine.LNX.4.33.0305131548130.29172-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Scheduled jobs  (Þórhallur Hálfdánarson <tolli@tol.li>)
Список pgsql-hackers
OK, here's an idea.  You write a set of stored procs that let you do 
something like:

insert into batch_jobs ('.....  I'm not sure what we'd put here...)

then, postgresql has a crontab entry that uses something like redhats 
runparts script to run the SQL commands it finds in the table.

I.e. the jobs could be scheduled by something as simple as a query, and 
removed as well.  Just need a postgresql cron that runs every 5 minutes or 
whatever resolution you need.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Þórhallur Hálfdánarson
Дата:
Сообщение: Re: Scheduled jobs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [INTERFACES] Last round (I think) of FE/BE protocol changes