Thread: Re: Question]
On 13/07/2009 09:02, hendra kusuma wrote: > On Sat, Jul 11, 2009 at 9:03 PM, Raymond O'Donnell <rod@iol.ie> wrote: > >> On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote: >> >>> I want to know if you can create a store procedure that run >>> automatically after a certain time, something like a timer in java. If >>> it exists, could you tell me how it is implemented?? >> Put your function in a file, and then create a cron job that runs psql >> taking its input from the file: >> >> psql -f <your_file> <your-database> >> >> Ray. >> > > Ray, you forgot to mention that cron only work under Linux :) Yeah, but you didn't say what OS you're on! :-) For Windows (if that's what you're using) there are various implementations of cron - one I like and use is pycron: http://www.kalab.com/freeware/pycron/pycron.htm ...much nicer than trying to get the Windows scheduler to cooperate. There's also pgAgent. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
""Raymond O'Donnell"" <rod@iol.ie> schreef in bericht news:4A5B4A6F.1080300@iol.ie... > On 13/07/2009 09:02, hendra kusuma wrote: >> On Sat, Jul 11, 2009 at 9:03 PM, Raymond O'Donnell <rod@iol.ie> wrote: >> >>> On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote: >>> >>>> I want to know if you can create a store procedure that run >>>> automatically after a certain time, something like a timer in java. If >>>> it exists, could you tell me how it is implemented?? >>> Put your function in a file, and then create a cron job that runs psql >>> taking its input from the file: >>> >>> psql -f <your_file> <your-database> >>> >>> Ray. >>> >> >> Ray, you forgot to mention that cron only work under Linux :) > > Yeah, but you didn't say what OS you're on! :-) > > For Windows (if that's what you're using) there are various > implementations of cron - one I like and use is pycron: > > http://www.kalab.com/freeware/pycron/pycron.htm > > ...much nicer than trying to get the Windows scheduler to cooperate. > There's also pgAgent. > > Ray. > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > rod@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > If you are using Windows: Windows has the build in: Scheduled-Task (this is the Windows-equivelant of the Unix-Cron). It can be found in the Configuration-Screen. Martie
Martie Krukkeland wrote on 13.07.2009 21:11: > If you are using Windows: > Windows has the build in: Scheduled-Task (this is the Windows-equivelant of > the Unix-Cron). > It can be found in the Configuration-Screen. Or simply using the "at" command