Hi Jayakumar,
PgAgent for windows
1) Run PgAgent.sql script in maintenance database (Postgres database by
default).
2) Install PgAgent service using the following command on command prompt -
C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u postgres
-p XXXX hostaddr=127.0.0.1 dbname=postgres user=Postgres
Replace the path of pgAgent if you are not using default installation path
of Postgres
Replace XXXX with the password of OS User Postgres (One given while
installing Postgres on windows)
dbname=postgres (change if your maintenance database is different.)
3) Login using Postgres user account in windows.
4) Try to access pgAdmin III tool in that login. (These two steps are
required to create pgpass.conf file under Postgres login account.)
5) Login back to your normal account.
6) Start pgAgent service using the following command on command prompt
Net start pgAgent
7) Create a new job using PgAdmin III
8) Under step tab click Add to add new step.
Specify some name
Kind SQL / Batch depending upon the kind of job to be performed.
Database on which the job is to be performed.
Definition tab would contain a SQL command if kind selected is SQL
Definition tab would contain path of Batch file if kind selected is
Batch
9) Under Schedule tab in Job window click Add to add new schedule for the
job
Specify some name
Specify the start date & time
Specify the end date and time
Specify days or weekdays, months when the task needs to be performed in
days tab
Specify time hours & Minutes when you want the task to be performed.
(Atleast One hour & minute to be selected.)
Specify exception if any when you do not want the task to be performed.
10) All set to work.
---
_ Vishal
From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>,
"Vishal Arora" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
Date: Mon, 16 Jul 2007 12:32:15 +0530
Dear Vishal,
Sorry ... I didn't recvd any mails from you and Ashish...Kindly send me
again..
Thanks & Regards
Jayakumar M
________________________________
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Mon 7/16/2007 12:27 PM
To: Jayakumar_Mukundaraju; [EMAIL PROTECTED]
Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup
Which place exactly .. I had given you full step by step .. didn't you
follow that? Be specific.
_ vishal
>From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
>To: "Vishal Arora" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org>
>Subject: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Mon, 16 Jul 2007 12:04:10 +0530
>
>
>Dear Vishal, Ashish,
>
>Still i am in that place only.. Kindly guide me...Give me some steps, how
>to automate the backup..
>
>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.
_________________________________________________________________
http://im.live.com/messenger/im/home/?source=hmtextlinkjuly07
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.
_________________________________________________________________
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
