Обсуждение: pgAgent job step reporting failure when batch command succeeds

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.

<p><tt><font size="2">> From: osleep <osleep@docfocus.ca></font></tt><br /><tt><font size="2">> To:
pgadmin-support@postgresql.org,</font></tt><br /><tt><font size="2">> Date: 15/08/2012 18:44</font></tt><br
/><tt><fontsize="2">> Subject: [pgadmin-support] pgAgent job step reporting failure when <br />> batch command
succeeds</font></tt><br/><tt><font size="2">> Sent by: pgadmin-support-owner@postgresql.org</font></tt><br
/><tt><fontsize="2">> <br />> Hey there,<br />> <br />> I am running PostgreSQL 9.0.8 and the latest
versionof pgAgent available<br />> through the Application StackBuilder using Windows Server 2003 Service Pack<br
/>>2.<br />> <br />> I have a job that has one batch command step that continually fails even<br />> though
thebatch command is successful. When I checked the pga_jobsteplog, I<br />> find that the line pertaining to the job
stepcontains the call used to<br />> execute the batch command and nothing else.<br />> <br />> Normally I've
foundthat batch steps report null unless there is an error.<br />> Is this causing pgAgent to consider the job step
failed?<br/>> <br />> Thanks,<br />> Owen Sleep<br />> <br />> <br />Hi Owen,</font></tt><br /><br
/><tt><fontsize="2">I've patched this and it should be available in the next version of pgAgent.</font></tt><br /><a
href="http://archives.postgresql.org/pgadmin-hackers/2012-07/msg00098.php"><fontcolor="#0000FF" face="serif"
size="3"><u>http://archives.postgresql.org/pgadmin-hackers/2012-07/msg00098.php</u></font></a><fontface="serif"
size="3"> </font><br/><br /><tt><font size="2">Not sure how this would work with EnterpriseDB's stack builder, but you
shouldbe able to pull the latest source when released and compile manually(?)</font></tt><br /><br /><tt><font
size="2">Regards</font></tt><br/><br /><tt><font size="2">Martin French.</font></tt><font
face="sans-serif">=============================================Romax Technology Limited Rutherford House Nottingham
Science& Technology Park Nottingham, NG7 2PZ England Telephone numbers: +44 (0)115 951 88 00 (main) For other
officelocations see: http://www.romaxtech.com/Contact ================================= =============== E-mail:
info@romaxtech.comWebsite: www.romaxtech.com ================================= ================ Confidentiality
StatementThis transmission is for the addressee only and contains information that is confidential and privileged.
Unlessyou are the named addressee, or authorised to receive it on behalf of the addressee you may not copy or use it,
ordisclose it to anyone else. If you have received this transmission in error please delete from your system and
contactthe sender. Thank you for your cooperation. =================================================</font>