From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAgent Steps Not Executed |
Date: | 2012-01-18 14:34:10 |
Message-ID: | CA+OCxozOjg-y8s85ZWyJW64vNvd07X9foCBZDiZE2-hp4kjgow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Mon, Jan 16, 2012 at 6:16 PM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
> On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote:
>
>> postgres=# select * from pgagent.pga_jobsteplog where jslid = 284;
>> -[ RECORD 1 ]------------------------------
>> jslid | 284
>> jsljlgid | 211
>> jsljstid | 1
>> jslstatus | s
>> jslresult | 0
>> jslstart | 2012-01-13 01:06:05.286733+00
>> jslduration | 06:01:33.881374
>> jsloutput |
>
> I did just discover that the schedule had an end date set. This happens to me sometimes: I open the schedule’s properties in pgAdmin3, and the current date and time is put in as an end time default value. If I don’t notice and delete it, it will be saved. It’s possible this happened to me while the first step was running, so that the second would never be called.
>
> Realized this when *neither* step ran last night. That certainly feels like a bug to me: if I have the “End” field blank (NULL), it should remain blank unless I set it.
Agreed - I've committed a fix for this.
>> In any event, I would expect both steps to appear in the Steps tab of the properties of the job itself. And they don’t. :-(
>
> This is still an issue, though.
And that one (which by some fluke worked correctly on Windows, but not my Mac).
Thanks!
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2012-01-18 16:52:52 | Re: pgAgent Steps Not Executed |
Previous Message | Little, Douglas | 2012-01-17 19:56:20 | psql default directory on windows |