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.
