X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2CC8A554DD for ; Wed, 2 Mar 2005 04:40:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12147-05 for ; Wed, 2 Mar 2005 04:40:00 +0000 (GMT) Received: from chn-dns.primus-india.net (chn-dns.primus-india.net [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id D40BF52A67 for ; Wed, 2 Mar 2005 04:39:58 +0000 (GMT) Received: from ivesia52 (vesia-138-190-chn.ivesia.com [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id j222XCfu012621 for ; Wed, 2 Mar 2005 08:03:14 +0530 Message-ID: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> From: "Aravindhan G.D" To: Subject: Scheduling/Automated Jobs in Postgre Date: Wed, 2 Mar 2005 10:09:53 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C51F0F.FA835A50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.096 tagged_above=0 required=5 tests=HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200503/14 X-Sequence-Number: 16512 This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C51F0F.FA835A50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, 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. 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. With Regards, Aravindhan. ------=_NextPart_000_0025_01C51F0F.FA835A50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
 
I need to do some user = defined jobs=20 when ever the Postgre server gets restarted. These tasks should be = automated one=20 i.e) When ever I restart the server the PL/SQL functions I have = defined=20 should be executed automatically without my intervention. This is to = record some=20 information like Audit Trails and some more.
 
Could any one tell me = how can I=20 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=20 I could get them.
 
With = Regards,
Aravindhan.
------=_NextPart_000_0025_01C51F0F.FA835A50--