Re: PG 9.1 Windows 7 64-bit pgAdmin says all pgAgent jobs fail

On 3/1/2012 4:20 AM, Dave Page wrote:
> On Thu, Mar 1, 2012 at 4:22 AM, Guy Rouillier<guyr@burntmail.com>  wrote:
>> On 2/29/2012 4:13 AM, Dave Page wrote:
>>>
>>> On Wed, Feb 29, 2012 at 7:39 AM, Guy Rouillier<guyr@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