Re: pgAgent STDERR and Time Zone Questions

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAgent STDERR and Time Zone Questions
Date: 2011-12-22 17:44:05
Message-ID: 19D0F5D7-CD10-4D89-8EC3-8C016D445C74@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2011-12-23 10:25:30 Re: pgAgent STDERR and Time Zone Questions
Previous Message Dave Page 2011-12-22 09:44:12 Re: pgAgent STDERR and Time Zone Questions