Re: pgAgent STDERR and Time Zone Questions

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