> From: osleep <osleep@docfocus.ca>
> To: pgadmin-support@postgresql.org,
> Date: 15/08/2012 18:44
> Subject: [pgadmin-support] pgAgent job step reporting failure when
> batch command succeeds
> Sent by: pgadmin-support-owner@postgresql.org
>
> 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
>
>
Hi Owen,

I've patched this and it should be available in the next version of pgAgent.
http://archives.postgresql.org/pgadmin-hackers/2012-07/msg00098.php 

Not sure how this would work with EnterpriseDB's stack builder, but you should be able to pull the latest source when released and compile manually(?)

Regards

Martin French.============================================= Romax Technology Limited Rutherford House Nottingham Science & Technology Park Nottingham, NG7 2PZ England Telephone numbers: +44 (0)115 951 88 00 (main) For other office locations see: http://www.romaxtech.com/Contact ================================= =============== E-mail: info@romaxtech.com Website: www.romaxtech.com ================================= ================ Confidentiality Statement This transmission is for the addressee only and contains information that is confidential and privileged. Unless you are the named addressee, or authorised to receive it on behalf of the addressee you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please delete from your system and contact the sender. Thank you for your cooperation. =================================================