Re: [ADMIN] Scheduled Events

From: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
To: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
Cc: Payal Singh <payal(at)omniti(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [ADMIN] Scheduled Events
Date: 2013-12-17 12:06:38
Message-ID: CABnqL32yqvwdpyct6aPv9h_xwf3NpkqcCbS2qJjtc44_5aUqsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

I'm using pgAgent you mentioned before. You can easily schedule recurring
tasks from within pgAdmin.

regards
mk

2013/12/11 Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>

> Resending...
>
> On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)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(at)omniti(dot)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...
>>>
>>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2013-12-17 14:46:55 Re: Notice about psql !
Previous Message Doom.zhou 2013-12-17 05:29:37 Notice about psql !

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Keller 2013-12-17 15:47:54 Re: [DOCS] Re: postgresql.org inconsistent (Re: PG replication across DataCenters)
Previous Message Tim Kane 2013-12-17 11:25:06 Re: pg_stat_tmp

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2013-12-17 14:54:43 Re: Query caching (with 8.3)
Previous Message Vik Fearing 2013-12-17 10:32:06 Re: Query caching (with 8.3)