pgAgent Job's "last result" is continuously "running" I am using PostgreSQL-9.3 on Ubuntu-14.04 and using &quot;/usr/share/pgadmin3/pgagent.sql&quot; I have configured my pgAdmin3 to use pgAgent. postgres is my maintenance Db and I have run the pgagent.sql content into it's SQL editor to bring the &quot;Jobs&quot; node in pgAdmin3-gui.
In order to check how does this pgAgent works, I made a sample Db and then a test table under it. I have properly configure the &quot;Steps&quot; and &quot;Schedule&quot; parameters. But after starting this newly created job from the Job node using &quot;right-click and run now&quot;, my step is running just once and then it's not terminating after the execution. I am sure that my SQL and other parameters are right since I have seen the table modification after the very first run of the step but then the step is not terminating. It's a simple insert SQL command.
Any help regarding why the step is not terminating?
This was a bug in pgagent, it has been fixed in http://git.postgresql.org/gitweb/?p=pgagent.git;a=commitdiff;h=f9bf1ccb27ebcfce00e7a6d467bc0e1b5ee9555e.