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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
