On Wed, Mar 02, 2005 at 10:09:53AM +0530, Aravindhan G.D wrote: > I need to do some user defined jobs when ever the Postgre server > gets restarted. These tasks should be automated one i.e) When ever > I restart the server the PL/SQL functions I have defined should be > executed automatically without my intervention. This is to record > some information like Audit Trails and some more.
You could add an appropriate command to your PostgreSQL startup script. > Could any one tell me how can I implement this in Postgre. Is > there any concept like "Scheduled Jobs" in Postgre. If so pls. > provide me with related informations or the links from where I could > get them. PostgreSQL doesn't have a scheduler -- most operating systems have one (e.g., cron on Unix-like systems), so that's what people use. (BTW, it's "PostgreSQL" or "Postgres", not "Postgre".) -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
