Postgres Pro
Downloads
Home   >   mailing lists

Thread: Scheduled Events

Scheduled Events

From
Dev Kumkar
Date:
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...

Re: [ADMIN] Scheduled Events

From
Dev Kumkar
Date:
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...

Re: Scheduled Events

From
Vick Khera
Date:
no. use cron to run a query that does what you need.


On Wed, Dec 11, 2013 at 6:38 AM, Dev Kumkar <devdas.kumkar@gmail.com> 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...

Re: [SQL] [ADMIN] Scheduled Events

From
Marcin Krawczyk
Date:
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...