Hi, I have successfully installed pgagent and scheduled the pgagent job in pgadmin (on both windows and linux - ubunut 10.04). However, i experience two different behaviors in windows and linux (none of which is expected and correct). The job is the simple insert SQL statement (for testing). insert into table (col1, col2) values (1,2); In both linux and windows, the row gets inserted in the table. However, in linux, the job keeps running and never finishes. In statistics tab in pgAdmin, the status is 'running' and in properties tab. Last result is 'running' as well. In windows, the jobs returns with a failure. so Last result in properties tab is 'Failed' (though row is inserted in a table). I have tried both by manually executing the job and scheduling it, the result is same. I have followed the instructions here for scheduling the job : http://www.pgadmin.org/docs/dev/pgagent-jobs.html http://www.pgadmin.org/docs/dev/pgagent-jobs.html For 'Job', no host agent is entered. 'Steps' consist of a single step where above SQL insert statement is provided and appropriate connection string provided. Connection seems to be no issue, nor the sql statement, as row does get inserted in the table. For testing i just selected current date and time (of course 1 to 2 minutes into future) as the schedule. Any input will be helpful. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgAgent-job-keeps-running-tp5719267.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
