On Friday, December 23, 2011, David E. Wheeler <da...@justatheory.com> wrote: > On Dec 23, 2011, at 2:25 AM, Dave Page wrote: > >> Hmm, that looks like it should work. I've just run some tests here, >> and can't find anything wrong. Successes are reported as such, and >> non-zero return values are reported as whatever the "on error" setting >> says they should be. Subsequent steps in a job are either processed or >> skipped correctly based on the return value and on error setting of >> the previous step(s). >> >> postgres=# postgres=# select * from pgagent.pga_jobsteplog; >> jslid | jsljlgid | jsljstid | jslstatus | jslresult | >> jslstart | jslduration | jsloutput >> -------+----------+----------+-----------+-----------+-------------------------------+-----------------+------------------------ >> 1 | 1 | 1 | s | 127 | 2011-12-23 >> 10:14:37.108296+00 | 00:00:00.182375 | >> 2 | 2 | 1 | s | 127 | 2011-12-23 >> 10:15:02.155214+00 | 00:00:00.052011 | > > Should those 127s be "s"?
No, I had it set to ignore failures then. >> 3 | 3 | 1 | f | 127 | 2011-12-23 >> 10:16:02.334791+00 | 00:00:00.0732 | >> 4 | 4 | 1 | f | 127 | 2011-12-23 >> 10:17:02.514272+00 | 00:00:00.113905 | >> 5 | 5 | 1 | f | 127 | 2011-12-23 >> 10:18:02.645482+00 | 00:00:00.087998 | This will be an error. >> 6 | 6 | 1 | f | 127 | 2011-12-23 >> 10:19:02.780288+00 | 00:00:00.08348 | This will be an error. >> 7 | 7 | 1 | i | 127 | 2011-12-23 >> 10:20:02.903824+00 | 00:00:00.201093 | This will be an error. >> 8 | 7 | 3 | s | 0 | 2011-12-23 >> 10:20:03.106797+00 | 00:00:00.004515 | This will be a success >> 9 | 8 | 1 | i | 127 | 2011-12-23 >> 10:21:03.088051+00 | 00:00:00.006627 | This will be an error. >> 10 | 8 | 3 | s | 0 | 2011-12-23 >> 10:21:03.096869+00 | 00:00:00.006623 | This will be a success >> (10 rows) >> >> Is it possible you've got the config right now, but the logs you >> posted were from a different config? > > Haven’t changed anything. I believe it’s the default configuration, as installed by Devrim’s new RPMs. Is there something else I should show you? Everything looks fine. Care to try some debugging? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
