Re: pgAgent STDERR and Time Zone Questions

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: pgAgent STDERR and Time Zone Questions
Дата
Msg-id 19D0F5D7-CD10-4D89-8EC3-8C016D445C74@justatheory.com
обсуждение исходный текст
Ответ на Re: pgAgent STDERR and Time Zone Questions  (Dave Page <dpage@pgadmin.org>)
Ответы Re: pgAgent STDERR and Time Zone Questions  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
On Dec 22, 2011, at 1:44 AM, Dave Page wrote:

> Which makes me think that either `rc`is not what gets put into jsresult, or that
`steps->GetString(wxT("jstonerror"))`is returning "s", too. Or that I’m completely misunderstanding something, of
course.:-) 
>
> What's in pgagent.pga_jobstep where jstid in (1, 3, 7)?

postgres=# select * from pgagent.pga_jobstep where jstid IN (1, 3, 7);
-[ RECORD 1 ]--------------------------------------------------------------------------
jstid      | 1
jstjobid   | 1
jstname    | Daily Liberation
jstdesc    |
jstenabled | t
jstkind    | b
jstcode    | analytics-datamart/bin/daily_liberator
jstconnstr |
jstdbname  |
jstonerror | f
jscnextrun | [null]
-[ RECORD 2 ]--------------------------------------------------------------------------
jstid      | 3
jstjobid   | 2
jstname    | Liberate subscriber_evid_override
jstdesc    |
jstenabled | t
jstkind    | b
jstcode    | analytics-datamart/bin/liberate_once proreporting subscriber_evid_override
jstconnstr |
jstdbname  |
jstonerror | f
jscnextrun | [null]
-[ RECORD 3 ]--------------------------------------------------------------------------
jstid      | 7
jstjobid   | 4
jstname    | Copy flat_evid_item
jstdesc    |
jstenabled | t
jstkind    | b
jstcode    | analytics-datamart/bin/liberate_once proreporting flat_evid_type
jstconnstr |
jstdbname  |
jstonerror | f
jscnextrun | [null]

Best,

David



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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: pgAgent STDERR and Time Zone Questions
Следующее
От: Dave Page
Дата:
Сообщение: Re: pgAgent STDERR and Time Zone Questions