What’s a Job?
SELECT function() is the simpliest way to way to call a function…
What does “requests_curr_req()” do?
EXECUTE function() will “work” depending upon what function does…
So, what do you mean “nothing worked”? Errors, zero results (but no failure), what?
You may want to look at section 39.12 in the documentation as well “Porting from Oracle PL/SQL” (section 39 itself is going to be helpful as well).
Have you considered professional support services that have previously done Oracle migrations? And no, I am not one of them.
David J.
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Leon Match
Sent: Tuesday, June 21, 2011 10:00 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Call procedure from a Job, Test a Job in pgAdmin?
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.match@convergia.net