Re: Automatic SQL command execution

=0D
--- On Fri, 6/27/08, Sean Davis <sdavis2@[EMAIL PROTECTED]
> wrote:=0D
=0D
>> Postgresql doesn't have tools to do that directly.  If=0D
>> you are on=0D
>> Linux or Unix, you can use cron; Windows probably has=0D
>> something=0D
>> similar to automate tasks.=0D
>> =0D
=0D
> I use nncron lite.  Free and cron file compatible.=0D
=0D
> http://www.nncron.ru/nncronlt/help/help.htm=0D
=0D
> Lewis R Cunningham=0D
=0D
> An Expert's Guide to Oracle Technology=0D
> http://blogs.ittoolbox.com/oracle/guide/=0D
=0D
> Postgres Forums=0D
> http://postgres.enterprisedb.com/forum.do=0D
=0D
=0D
Actually you can use PgAgent which comes packaged with PgAdmin III.=0D
I've used it successfully on both windows and RedHat linux.  I think it=0D
works anywhere PostgreSQL works.  The nice thing about PgAgent is that=0D
you can see the status of jobs from the PgAdmin administrative tool and=0D
trigger a manual run of a scheduled job from PgAdmin tool from
anywhere.=0D
=0D
=0D
http://www.pgadmin.org/docs/1.8/pgagent.html=0D
=0D
Hope that helps,=0D
Regina=0D
-----------------------------------------=0D
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=0D
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.=0D


--=20
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice