Re: Time trigger - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Time trigger
Date
Msg-id 43733A03.7000206@wildenhain.de
Whole thread Raw
In response to Time trigger  ("Piechu Piechu" <piechutm@wp.pl>)
List pgsql-general
Piechu Piechu schrieb:
> hello
>
> I'm new in this list, so sorry if my question seems stupid
>
> Is it possible to invoke store procedure because of time, I mean for example I want my procedure to be invoked every
tenminutes - what should I do to reach this goal 
>

Usually one takes the system cron service to start a script
which in turn acts on the database in the way you want.
Since you are using windows, you perhaps have no built in
way (although I remember there was an ability with IE
offline pages you can use to timely trigger things iirc)
but there are many "cron" - like tools for download
you could use.

Postgres has currently no built in for that because
the vast number of instances run on some unices where
cron is common.

HTH
Tino Wildenhain

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Time trigger
Next
From: Tino Wildenhain
Date:
Subject: Re: PL language selection