Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: PgAgent does not works



Khan, Mahmood Ahram wrote:
I have also tried that. When i create a new job I think some rows should
be written to the tables in the pgagent schema. But when I am checking
physically the tables there is no data. Is that so due to service of
pgagent.

pgagent itself doesn't have any effect on the creation of jobs. In your case, it sounds like the schema is not where you think it is, or you have a second one and you and pgAdmin do not agree on which is the right one.

Check which database is your maintenance DB (look at the server properties), and then look in the pgagent schema in *that* database.

Regards, Dave



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group