Thread: pgAgent question
Hello!<br /><br /> Excuse me, I'm not sure this pgadmin list allow pgagent question.<br /><br /> Is there any way to executescheduled job often than every 1-2 minutes?<br /><br /> Regards<br /> Dmitry Mordovin<br /><br />
On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote: > Hello! > > Excuse me, I'm not sure this pgadmin list allow pgagent question. Yes, it does. > Is there any way to execute scheduled job often than every 1-2 minutes? No. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On 12/16/2010 01:32 PM, Dave Page wrote: <blockquote cite="mid:AANLkTikv8UBfPhLxA1wQfZ1XG6z4AQAhNkaqRrRXY3T-@mail.gmail.com"type="cite"><pre wrap="">On Thu, Dec 16, 2010 at 11:29AM, Dmitry Mordovin <a class="moz-txt-link-rfc2396E" href="mailto:d.mordovin@dwide.com"><d.mordovin@dwide.com></a>wrote: </pre><blockquote type="cite"><pre wrap="">Hello! Excuse me, I'm not sure this pgadmin list allow pgagent question. </pre></blockquote><pre wrap=""> Yes, it does. </pre><blockquote type="cite"><pre wrap="">Is there any way to execute scheduled job often than every 1-2 minutes? </pre></blockquote><pre wrap=""> No. </pre></blockquote> Hi Dave!<br /><br /> How about to add this in TODO list?<br /><br /> May be, I can think about simplesolution.<br /><br /> Dmitry<br /><br />
On Thu, Dec 16, 2010 at 11:35 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote: > On 12/16/2010 01:32 PM, Dave Page wrote: > > On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin <d.mordovin@dwide.com> > wrote: > > Hello! > > Excuse me, I'm not sure this pgadmin list allow pgagent question. > > Yes, it does. > > Is there any way to execute scheduled job often than every 1-2 minutes? > > No. > > Hi Dave! > > How about to add this in TODO list? > > May be, I can think about simple solution. It would add a lot of extra complexity that noone (other than you) that I can recall has asked for in the past. Also, if you need to process something that frequently, then pgAgent probably isn't going to be the best solution for you anyway, due to the way it polls the jobs table to check for things to run. You would probably want something that polls, caches and then executes all the tasks over the next few minutes, before starting over. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company