Re: pgAgent Steps Not Executed

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: pgAgent Steps Not Executed
Дата
Msg-id CA+OCxowx-OBrCB+HSpX3tG=rz+KBgPHj1PFW3iU5djMeatnV6Q@mail.gmail.com
обсуждение исходный текст
Ответ на pgAgent Steps Not Executed  ("David E. Wheeler" <david@justatheory.com>)
Ответы Re: pgAgent Steps Not Executed  ("David E. Wheeler" <david@justatheory.com>)
Список pgadmin-support
Hi

On Sun, Jan 15, 2012 at 7:18 PM, David E. Wheeler <david@justatheory.com> wrote:
pgAdmins,

I added a new step to a pgAgent job a couple days ago, but noticed it has not been executing. It  is listed under the job's steps in the pgAdmin object browser, as shown in the attached screenshot. However, when I view the properties of the job itself, and select the "Steps" tab, the second step is *not* shown (also shown in the screen shot).

So in one place pgAdmin sees both steps, but in another it does not. I assume that pgagent is using whatever algorithm does not see the second, just like the Steps tab of the job properties.



FWIW, both steps appear for this query:

postgres=# select * from pgagent.pga_jobstep where jstjobid = 1;
-[ RECORD 1 ]-----------------------------------------------------------------------------------------------------------------------------------------------------------
jstid      | 1
jstjobid   | 1
jstname    | Liberate Logical
jstdesc    | 
jstenabled | t
jstkind    | b
jstcode    | echo "foo"
jstconnstr | 
jstdbname  | 
jstonerror | f
jscnextrun | [null]
-[ RECORD 2 ]-----------------------------------------------------------------------------------------------------------------------------------------------------------
jstid      | 29
jstjobid   | 1
jstname    | Liberate Reporting
jstdesc    | 
jstenabled | t
jstkind    | b
jstcode    | echo "bar"
jstconnstr | 
jstdbname  | 
jstonerror | f
jscnextrun | [null]


Bug? I’m using pgAgent 3.0.1 built for the pgrpms repo and pgAdmin3 1.14.1 built for Mac OS X.


Depends on what the first step is doing. You have On Error set to Fail, which will cause subsequent steps to be skipped if an error is detected. What do you see in the job step log for the first step? 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: pgAgent Steps Not Executed
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: pgAgent Steps Not Executed