Re: Schedules Running Problem

Thanks to all in the Group,

          Now my Schedule is Running.....

The Steps i have taken are given below:-


 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

if the above command didnot work suceefully then u can use the following Command:----

 go to the Diectory path("C:\Program Files\PostgreSQL\8.2\bin") and run the Command
 
 pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX hostaddr=127.0.0.1 dbname=postgres
 user=postgres password=XXXX

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

    Edit the pgpass.conf File with the Following Line :----
   
    localhost:PortNumber:myDBname:myUserName:myPassword
   
     *:*:*:*:Password
    in both the Account Postgres and your Local Login Account. The Pgpass.Conf File is located in
    %ApplicationData%/postgres/

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.








--
Best Regards,
Yogesh Arora
Asst. Software Engg.
Daffodil Software Pvt. Ltd.,
Mobile: 09255123173
Web :  www.daffodildb.com