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"
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.
