Re: PgAgent Job Scheduling-Backup

>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>
>To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>, "Vishal
>Arora" <aroravishal22(at)hotmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
>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(at)postgresql(dot)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