Re: Help with pgagent

Поиск
Список
Период
Сортировка
От Ajlinux
Тема Re: Help with pgagent
Дата
Msg-id jMJjENXQjBEZzcHqSt8-aWReXuEgpgUWna6lkj5YAQHqtaVPG6wNN5WIHNxOM43DuKl3nTfow8rknCm5i4IzyNskSpQqL9Szi6bZhZB8p0c=@protonmail.com
обсуждение исходный текст
Ответ на Re: Help with pgagent  (Dave Page <dpage@pgadmin.org>)
Ответы Re: Help with pgagent  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
Дерево обсуждения
Hi Dave

Many thanks for the response, couple of other questions:

1) If I use a job step to call a bash script - quite rightly if the script executes and completes it shows with Status of S.  If I change the script exit code on an error - can I trigger a separate status to be recorded?

2) if we have a step that shows as running, how can we mark that as done and move on to the next step in the job?

Thanks

AJ




‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On 13 July 2018 2:29 PM, Dave Page <dpage@pgadmin.org> wrote:



On Fri, Jul 13, 2018 at 11:23 AM, Ajlinux <ajlinux@protonmail.com> wrote:
Hi

I was wondering if anyone can help.  I am running a Postgresql 9.4 server on Ubuntu 14.04 and having issues with pageant jobs saying that they are running but the jobs are not doing anything.  This is not every job and it appears that the issue happens at random.  I am running pgaent v3.4.1.

I was just wondering if anyone has any code to help diagnose pageant issues.  The executable works fine and does not crash and there are no errors in the pageant log.

Have you tried increasing the log level to get more detailed info about the schedulers operation?
 


Also, does anyone one have code they can share to reset stuck jobs in the pageant tables as I am doing but not sure if I am doing it correctly as have a limited understanding of how all the pieces fit together.

The agent should run any job that has it's "jobnextrun" value in the pga_job table less than or equal to the current time, with jobenabled = true and jobagentid = NULL, each time it checks for jobs to run. If you've got an entry in that table for a job that you think should have run but did not, please share the data and we may be able to see why.
 

Also does anyone have a technical overview of how it works?

Not really, unfortunately. 
 

--
Dave Page
Twitter: @pgsnake

The Enterprise PostgreSQL Company

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Help with pgagent
Следующее
От: Dave Page
Дата:
Сообщение: Re: Help with pgagent