Re: Not found pgAgent Jobs in pgAdmin

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