Re: pgagent status always successful

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Eric Shuman
> Sent: 29 June 2006 20:06
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] pgagent status always successful
>
> I am new to pgadmin and pgagent and need some help.
>
> I am trying to set up a job in pgadmin3 that runs
> automatically through
> pgagent.  I want the job to stop if any of the steps fail.
> Some of the steps
> are bash scripts.  I have set the "On Error" flag to fail.
>
> I can get my bash scripts to run through pgagent, but the
> status of the
> script always comes back as "Successful" with a result of "1" (in the
> statistics section for the step in pgadmin), this happens
> even if I use an
> invalid filename for the script. I have also tried exiting
> the scripts with
> various exit codes and have used "set -e" with out effect.
>
> Is this a bug or am I missing something obvious?  Can anyone
> give me some
> advice on setting up jobs?

Yes, it's a bug. Please give the attached patch to xtra/pgagent/job.cpp
a whirl and see if it helps. You should get a result of -1 if there is
an error executing the script, otherwise whatever the return value of
the script is.

Note that on Windows there is currently no way to get the script return
value.

Please let me know if it works as expected.

Regards, Dave