Thread: Not found pgAgent Jobs in pgAdmin
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)
TIA,
Sabin
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