On Dec 19, 2011, at 1:52 AM, Dave Page wrote: >> FYI, I have "On error" set to "Fail". > > What's actually in pgagent.pga_jobsteplog?
postgres=# select * from pgagent.pga_jobsteplog where jslresult <> 0; jslid | jsljlgid | jsljstid | jslstatus | jslresult | jslstart | jslduration | jsloutput -------+----------+----------+-----------+-----------+-------------------------------+-----------------+----------- 1 | 1 | 1 | s | 127 | 2011-12-15 16:49:25.038705-08 | 00:00:00.024641 | 2 | 2 | 1 | s | 15 | 2011-12-15 17:23:03.637553-08 | 00:00:02.496322 | 3 | 3 | 1 | s | 15 | 2011-12-15 17:25:58.995506-08 | 00:00:00.281899 | 6 | 6 | 3 | s | 5 | 2011-12-16 10:46:46.047913-08 | 00:00:00.265507 | 10 | 10 | 7 | s | 5 | 2011-12-16 15:31:34.899431-08 | 00:00:00.071114 | 11 | 11 | 7 | s | 5 | 2011-12-16 15:38:30.729017-08 | 00:00:00.071268 | 12 | 12 | 7 | s | 5 | 2011-12-16 15:39:00.797969-08 | 00:00:00.073382 | (7 rows) Best, David