Re: Not found pgAgent Jobs in pgAdmin - Mailing list pgadmin-support

From Dave Page
Subject Re: Not found pgAgent Jobs in pgAdmin
Date
Msg-id 45EC0698.3060605@postgresql.org
Whole thread Raw
In response to Not found pgAgent Jobs in pgAdmin  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgadmin-support
Sabin Coanda wrote:
> Hi there,
>  
> I have the database "MyDBTest" on my local server.
>  
> I installed pgAgent service on my local PC with the following command:
> "D:\Program Files\PostgreSQL\8.2\bin\pgAgent.exe" INSTALL
> pgAgent_MyDBTest -u postgres -p xxx hostaddr=127.0.0.1 dbname="MyDBTest"
> user=postgres
>  
> The service is running well an I don't find any error messages in the
> event logs.
>  
> The problem is that I don't find Jobs node in pgAdmin.
>  
> I use the following environment:
> 
>     * Windows XP sp2
>     * English language
>     * "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe
>       (GCC) 3.4.2 (mingw-special)"
>     * pgAdmin v.1.6.2( Jan 6 2007, rev:5837)

You must run the pgAgent SQL script in the same database that pgAgent
connects to and pgAdmin uses as it's maintenance DB. Normally this would
be the postgres database.

Regards, Dave


pgadmin-support by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Not found pgAgent Jobs in pgAdmin
Next
From: "Sabin Coanda"
Date:
Subject: pgAgent jobs by script