Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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


pgadmin-support by date

Next:From: postgresql.orgDate: 2006-06-29 19:37:28
Subject: pgAdmin: not remembering passwords
Previous:From: Devrim GUNDUZDate: 2006-06-29 12:09:14
Subject: pgAdmin3 RHEL4 RPMs

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group