| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgresql.org | 2006-06-29 19:37:28 | pgAdmin: not remembering passwords |
| Previous Message | Devrim GUNDUZ | 2006-06-29 12:09:14 | pgAdmin3 RHEL4 RPMs |