Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C55B49FB856 for ; Tue, 17 Jul 2007 01:14:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82019-08 for ; Tue, 17 Jul 2007 01:13:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc1-s20.bay0.hotmail.com (bay0-omc1-s20.bay0.hotmail.com [65.54.246.92]) by postgresql.org (Postfix) with ESMTP id D8BC89FB5CA for ; Tue, 17 Jul 2007 01:13:58 -0300 (ADT) Received: from hotmail.com ([207.46.11.112]) by bay0-omc1-s20.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 16 Jul 2007 21:13:57 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 16 Jul 2007 21:13:57 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Tue, 17 Jul 2007 04:13:52 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E04C4E89A@hcsmsg002.corp.satyam.ad> From: "Vishal Arora" To: Jayakumar_Mukundaraju@satyam.com, ashish.karalkar@info-spectrum.com, pgsql-admin@postgresql.org Subject: Re: PgAgent Job Scheduling-Backup Date: Tue, 17 Jul 2007 04:13:52 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 17 Jul 2007 04:13:57.0815 (UTC) FILETIME=[E582CC70:01C7C828] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/165 X-Sequence-Number: 26146 >From: "Jayakumar_Mukundaraju" >To: "Ashish Karalkar" , "Vishal >Arora" , >Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup >Date: Mon, 16 Jul 2007 19:23:20 +0530 > >Dear Vishal / Ashish > > > I did these steps only... > > > >1. I get the pgAgent.sql script in pgAdmin III directory , I copied that >scripts and execute the scripts in my default postgres database. > >2. After, I get the jobs icon in our postgres. > >3. In that jobs icon I given jobs name,schedule name and steps > > In steps tab I given the step name , Enabled, Database name > > Kind : SQL , On error is: Fail > > Comment : postgres backup > >In definition box : I given this command pg_dump postgres >"D:\AGBACKUP\AG.sql" Can you run this command in psql prompt as it is shown here? I am repeatedly telling you that this is not a SQL command. You can not run this while KIND Is SQL. put this command in Batch file and select Kind as Batch then run it. > > > >These steps only I did it... > > >Thanks & Regards >Jayakumar M > > > >________________________________ > >From: Jayakumar_Mukundaraju >Sent: Mon 7/16/2007 6:19 PM >To: Ashish Karalkar; Vishal Arora; pgsql-admin@postgresql.org >Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup > > >Dear Vishal/Ashish > >In my pgpass.conf file there is two password is there.. both the passwords >are same >Host Port Database UserName Password >localhost: 5432: postgres: postgres: satyam123$ >localhost: 5432: *: postgres: satyam123$ > >Thanks & Regards >Jayakumar M > > > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. _________________________________________________________________ Don't get caught with egg on your face. Play Chicktionary!  http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2