Call procedure from a Job, Test a Job in pgAdmin?

From: "Leon Match" <leon(dot)match(at)convergia(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Call procedure from a Job, Test a Job in pgAdmin?
Date: 2011-06-21 13:59:38
Message-ID: 000a01cc301b$760fa9d0$622efd70$@match@convergia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Could you please advise on how to call a Procedure (Function) from a Job?

I have created a Job with one step, and a scheduler.

The Job is suppose to run every minute, and call a procedure (function).

I tried different scenarios in a Step Definition:

requests_curr_req();

SELECT requests_curr_req();

EXECUTE requests_curr_req();

EXECUTE PROCEDURE requests_curr_req();

but nothing worked!?

Could you please advise the right way to do that?

Also, what would be the way to test in pgAdmin, if the Job is running at
all?

Thank you,

Leon Match

leon(dot)match(at)convergia(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-06-21 14:00:42 Re: Help needed with PostgreSQL clustering/switching from MySQL
Previous Message Vick Khera 2011-06-21 13:49:54 Re: 2 questions re RAID