Skip site navigation (1) Skip section navigation (2)

Re: Automatic SQL command execution

From: "Yos Sunitiyoso" <yos(dot)sunitiyoso(at)gmail(dot)com>
To: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>, "Lewis Cunningham" <lewisc(at)rocketmail(dot)com>, "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Automatic SQL command execution
Date: 2008-07-02 09:42:48
Message-ID: 8da2d3e60807020242q38c1ab2ej13a597d8849a23d6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Dear Sean, Lewis and Regina,

Many thanks for your suggestions. It looks there are several options
doing automatic tasks on PostgreSQL.
I found that Windows has a task scheduler. I tried to use it but still
have problem in connecting with the server (and database). I may need
to learn setting the correct parameters.
I will try to use the PgAgent or nncronlite as they seem to be better
options. I hope you would help me again if I have further questions.
Many thanks.

Kind regards,

Yos

On Tue, Jul 1, 2008 at 8:30 PM, Obe, Regina <robe(dot)dnd(at)cityofboston(dot)gov> wrote:
>
> --- On Fri, 6/27/08, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
>>> Postgresql doesn't have tools to do that directly.  If
>>> you are on
>>> Linux or Unix, you can use cron; Windows probably has
>>> something
>>> similar to automate tasks.
>>>
>
>> I use nncron lite.  Free and cron file compatible.
>
>> http://www.nncron.ru/nncronlt/help/help.htm
>
>> Lewis R Cunningham
>
>> An Expert's Guide to Oracle Technology
>> http://blogs.ittoolbox.com/oracle/guide/
>
>> Postgres Forums
>> http://postgres.enterprisedb.com/forum.do
>
>
> Actually you can use PgAgent which comes packaged with PgAdmin III.
> I've used it successfully on both windows and RedHat linux.  I think it
> works anywhere PostgreSQL works.  The nice thing about PgAgent is that
> you can see the status of jobs from the PgAdmin administrative tool and
> trigger a manual run of a scheduled job from PgAdmin tool from anywhere.
>
>
> http://www.pgadmin.org/docs/1.8/pgagent.html
>
> Hope that helps,
> Regina
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
>
>

In response to

pgsql-novice by date

Next:From: NetzachDate: 2008-07-02 10:21:01
Subject: Calculating repeating events - functionality lost with the demise of tinterval ?
Previous:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2008-07-02 08:54:08
Subject: Table exists but can't drop.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group