Обсуждение: Scheduled Events
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.
Resending...
On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrote:
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...
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...
I'm using pgAgent you mentioned before. You can easily schedule recurring tasks from within pgAdmin.
regards
mk
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...