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

Поиск
Список
Период
Сортировка
От Leon Match
Тема Call procedure from a Job, Test a Job in pgAdmin?
Дата
Msg-id 000a01cc301b$760fa9d0$622efd70$@match@convergia.net
обсуждение исходный текст
Ответы Re: Call procedure from a Job, Test a Job in pgAdmin?
Список 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.match@convergia.net

 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: 2 questions re RAID
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Help needed with PostgreSQL clustering/switching from MySQL