Re: PgAgent Job Scheduling-Backup

>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