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