pgagent status always successful

From: "Eric Shuman" <erics(at)ameri-title(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgagent status always successful
Date: 2006-06-29 19:06:01
Message-ID: 000201c69baf$107b5ca0$a514a8c0@GIS1
Views: Raw Message | Whole Thread | Download mbox
Lists: pgadmin-support

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?

Thanks for the help,

~ Eric


Browse pgadmin-support by date

  From Date Subject
Next Message 2006-06-29 19:37:28 pgAdmin: not remembering passwords
Previous Message Devrim GUNDUZ 2006-06-29 12:09:14 pgAdmin3 RHEL4 RPMs