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: 7205B42C-7A31-4A3B-8142-8EBE81FE4375@justatheory.com (view raw or flat)
Thread:
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? 

Success:

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

David


In response to

Responses

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-2014 The PostgreSQL Global Development Group