Re: [SQL] [ADMIN] Scheduled Events

Поиск
Список
Период
Сортировка
От Marcin Krawczyk
Тема Re: [SQL] [ADMIN] Scheduled Events
Дата
Msg-id CABnqL32yqvwdpyct6aPv9h_xwf3NpkqcCbS2qJjtc44_5aUqsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Scheduled Events  (Dev Kumkar <devdas.kumkar@gmail.com>)
Список pgsql-general
I'm using pgAgent you mentioned before. You can easily schedule recurring tasks from within pgAdmin.

regards
mk


2013/12/11 Dev Kumkar <devdas.kumkar@gmail.com>
Resending...

On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
Yes actually that's one alternate solution to use cron or windows scheduled tasks.

The intent is to call certain stored procedures at certain time intervals.


On Wed, Dec 11, 2013 at 7:24 PM, Payal Singh <payal@omniti.com> wrote:
You can schedule those jobs in a crontab. If it is a SQL command, you can use  the -c option with psql.


On Wed, Dec 11, 2013 at 05:08:12PM +0530, Dev Kumkar wrote:
> How to create scheduled events in postgres simillar to whats event in
> Sybase.
> Is there any method of doing so?
>
> Also am looking at PgAgent which can create jobs but is it similar like
> events in sybase.
>
> Please suggest.
>
> Regards...

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

Предыдущее
От: Tim Kane
Дата:
Сообщение: Re: pg_stat_tmp
Следующее
От: Wolfgang Keller
Дата:
Сообщение: Re: [DOCS] Re: postgresql.org inconsistent (Re: PG replication across DataCenters)