Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-16 Thread Dave Page
novnov wrote: > Thank you, just had time to test this. > > I wrote a simple sproc that adds a row to a test table. I've created a one > step job > > db = db the sproc is in > kind = sql > def = SELECT proc_test01_insertrow(); > > set to run on each minute of every hour every day, starting toda

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-16 Thread novnov
Thank you, just had time to test this. I wrote a simple sproc that adds a row to a test table. I've created a one step job db = db the sproc is in kind = sql def = SELECT proc_test01_insertrow(); set to run on each minute of every hour every day, starting today 00:00:01 The job, step, and sc

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-13 Thread Dave Page
> --- Original Message --- > From: novnov <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Sent: 13/08/07, 17:36:12 > Subject: [GENERAL] Running a stored procedure via pgagent, need an example > > Can someone give me a simple example of the way in which I might be able to > call