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

Re: pgAgent Steps Not Executed

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 Steps Not Executed
Date: 2012-01-16 17:05:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
On Jan 16, 2012, at 7:45 AM, Dave Page wrote:

> Depends on what the first step is doing. You have On Error set to Fail, which will cause subsequent steps to be skipped if an error is detected. What do you see in the job step log for the first step? 


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   | 

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


In response to


pgadmin-support by date

Next:From: David E. WheelerDate: 2012-01-16 18:16:05
Subject: Re: pgAgent Steps Not Executed
Previous:From: Dave PageDate: 2012-01-16 15:45:54
Subject: Re: pgAgent Steps Not Executed

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