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.

> 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.

Thanks,

David
-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to