On 3/1/2012 4:20 AM, Dave Page wrote:
On Thu, Mar 1, 2012 at 4:22 AM, Guy Rouillier<g...@burntmail.com> wrote:
On 2/29/2012 4:13 AM, Dave Page wrote:
On Wed, Feb 29, 2012 at 7:39 AM, Guy Rouillier<g...@burntmail.com> wrote:
So, now the only remaining issue is that in PgAdmin, the Statistics tab
shows all runs with a status of "Failed". But the datetest table is
getting
updated properly. I see no events in the Application event log.
Finally, I
ran pgAgent from the command line in DEBUG mode:
DEBUG: Checking for jobs to run
DEBUG: Creating job thread for job 2
DEBUG: Creating DB connection: user=postgres port=5432 hostaddr=1270.0.1
password=xxxx dbname=postgres
DEBUG: Allocating new connection to database postgres
DEBUG: Starting job: 2
DEBUG: Sleeping...
DEBUG: Creating DB connection: user=postgres port=5432 hostaddr=1270.0.1
password=xxxx dbname=postgres dbname=postgres
DEBUG: Allocating new connection to database postgres
DEBUG: Executing SQL step 3 (part of job 2)
DEBUG: Returning connection to database postgres
DEBUG: Returning connection to database postgres
DEBUG: Completed job: 2
DEBUG: Destroying job thread for job 2
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
The run also shows a status of "Failed". Any idea why? Thanks.
The step or the job shows as failed? What's the output from the step?
Both the step and the job are shown as failed. Thanks.
And the step output?
I think you are referring to the "Output" column in the Statistics tab.
That column is completely blank for all tests.
Thanks.
--
Guy Rouillier
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
