Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1C94364FCDA for ; Tue, 25 Nov 2008 06:32:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01020-08 for ; Tue, 25 Nov 2008 06:32:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web65707.mail.ac4.yahoo.com (web65707.mail.ac4.yahoo.com [76.13.9.99]) by mail.postgresql.org (Postfix) with SMTP id C423D64FC38 for ; Tue, 25 Nov 2008 06:32:48 -0400 (AST) Received: (qmail 43533 invoked by uid 60001); 25 Nov 2008 10:32:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=0jfmtEmzGpyyvOisqA7R9Roy12Kjl0g6qmurvn5pXr6lvu/3KG8hwsiOLgnxOf1UqsVV3N2BagZPA2sh1PphGoBnrV0ziQZABDbc2LpcAZeHYEprzG5GpTEq7VBZi+TC/Ex/VWrdgtOsfdyg7hUktlpmgWQ5BglgNpy2G9hX9dE=; X-YMail-OSG: Er54xHMVM1kOu4gjX9su0Q3qiWmyPNGaJnziPOdKafYbWO_mYdCwbCq14b.kveWG_XGDPPRHKbVLGaxSBKQq4ZV4CM8BzgeYMHBeIpyXUQvmSfu85tcOSDQ_T8Tk0yPgYn2sSuYhQlCx_BLBPQUwjBluH45DjWC.5egXDD3BG3lT8xk- Received: from [125.209.91.158] by web65707.mail.ac4.yahoo.com via HTTP; Tue, 25 Nov 2008 02:32:46 PST X-Mailer: YahooMailRC/1155.32 YahooMailWebService/0.7.260.1 References: <445095.85132.qm@web65712.mail.ac4.yahoo.com> Date: Tue, 25 Nov 2008 02:32:46 -0800 (PST) From: Abdul Rahman Subject: Re: PgAgent Job Scehduler is NOT running To: Vishal Arora , pgsql-admin@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-897058780-1227609166=:43396" Message-ID: <239268.43396.qm@web65707.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200811/141 X-Sequence-Number: 30795 --0-897058780-1227609166=:43396 Content-Type: text/plain; charset=us-ascii Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . ________________________________ From: Vishal Arora To: abr_ora@yahoo.com Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. ________________________________ Date: Mon, 24 Nov 2008 23:23:15 -0800 From: abr_ora@yahoo.com Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. ----- Forwarded Message ---- From: Vishal Arora To: abr_ora@yahoo.com; pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. ________________________________ Date: Sun, 23 Nov 2008 23:51:46 -0800 From: abr_ora@yahoo.com Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: pgsql-admin@postgresql.org Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. ________________________________ Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! ________________________________ Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! --0-897058780-1227609166=:43396 Content-Type: text/html; charset=us-ascii
Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .

From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.

Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.


----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.

Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org

Dear all,

I  installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.


Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!


Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!

--0-897058780-1227609166=:43396--