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