How to indicate failure of a shell script to pgagent

Поиск
Список
Период
Сортировка
От Wappler, Robert
Тема How to indicate failure of a shell script to pgagent
Дата
Msg-id C8E2DAF0E663A948840B04023E0DE32A02E2AF2F@w2k3server02.de.ophardt.com
обсуждение исходный текст
Список pgsql-general
Hi,
I'm using postgresql 8.4.5 and pgagent 1.8.4 on debian lenny. I set up a pgagent job, which executes every 15 minutes.
Inone step, there is a shell script executed. For testing purposes, the script is simply a one-liner containing "exit
1".Nevertheless, pgAdmin tells me, the job executed successful. 

So my question is: How can a shell script indicate a failure to pgagent, so that the job execution is considered to be
failed?

The step's attribute is set to fail-on-error.

Thanks in advance





 


В списке pgsql-general по дате отправления:

Предыдущее
От: Ben Chobot
Дата:
Сообщение: Re: how can i bugfix "idle in transaction" lockups ?
Следующее
От: A J
Дата:
Сообщение: Extension for file management under postgres