Re: [SQL] [ADMIN] Scheduled Events - Mailing list pgsql-general

From Marcin Krawczyk
Subject Re: [SQL] [ADMIN] Scheduled Events
Date
Msg-id CABnqL32yqvwdpyct6aPv9h_xwf3NpkqcCbS2qJjtc44_5aUqsQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Scheduled Events  (Dev Kumkar <devdas.kumkar@gmail.com>)
List 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 by date:

Previous
From: Tim Kane
Date:
Subject: Re: pg_stat_tmp
Next
From: Wolfgang Keller
Date:
Subject: Re: [DOCS] Re: postgresql.org inconsistent (Re: PG replication across DataCenters)