Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group