pgAgent job step reporting failure when batch command succeeds

From: osleep <osleep(at)docfocus(dot)ca>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAgent job step reporting failure when batch command succeeds
Date: 2012-08-15 17:39:40
Message-ID: 1345052380430-5719955.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hey there,

I am running PostgreSQL 9.0.8 and the latest version of pgAgent available
through the Application StackBuilder using Windows Server 2003 Service Pack
2.

I have a job that has one batch command step that continually fails even
though the batch command is successful. When I checked the pga_jobsteplog, I
find that the line pertaining to the job step contains the call used to
execute the batch command and nothing else.

Normally I've found that batch steps report null unless there is an error.
Is this causing pgAgent to consider the job step failed?

Thanks,
Owen Sleep

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pgAgent-job-step-reporting-failure-when-batch-command-succeeds-tp5719955.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Evan Martin 2012-08-16 02:56:30 Query output is misleading due to grid cell size
Previous Message Colin Beckingham 2012-08-15 13:55:33 Font size control in edit data window