| From: | "Martin French" <Martin(dot)French(at)romaxtech(dot)com> |
|---|---|
| To: | osleep <osleep(at)docfocus(dot)ca> |
| Cc: | pgadmin-support(at)postgresql(dot)org,pgadmin-support-owner(at)postgresql(dot)org |
| Subject: | Re: pgAgent job step reporting failure when batch command succeeds |
| Date: | 2012-08-16 06:33:54 |
| Message-ID: | OF5BA533AC.D3275C14-ON80257A5C.0023C21D-80257A5C.0024106D@LocalDomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
<html><body><p><tt><font size="2">> From: osleep <osleep(at)docfocus(dot)ca></font></tt><br><tt><font size="2">> To: pgadmin-support(at)postgresql(dot)org, </font></tt><br><tt><font size="2">> Date: 15/08/2012 18:44</font></tt><br><tt><font size="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(at)postgresql(dot)org</font></tt><br><tt><font size="2">> <br>> Hey there,<br>> <br>> I am running PostgreSQL 9.0.8 and the latest version of 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 the batch command is successful. When I checked the pga_jobsteplog, I<br>> find that the line pertaining to the job step contains the call used to<br>> execute the batch command and nothing else.<br>> <br>> Normally I've found that 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><font size="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"><font size="3" color="#0000FF" face="serif"><u>http://archives.postgresql.org/pgadmin-hackers/2012-07/msg00098.php</u></font></a><font size="3" face="serif"> </font><br><br><tt><font size="2">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(?)</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 office locations see:
http://www.romaxtech.com/Contact
=================================
===============
E-mail: info(at)romaxtech(dot)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.
=================================================</font>
</body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Clarke (M4 Systems Ltd) | 2012-08-18 07:54:37 | pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18 |
| Previous Message | Evan Martin | 2012-08-16 02:56:30 | Query output is misleading due to grid cell size |