Need to run a job in PgAdmin-III

On 09/23/12 11:24 PM, pavithra wrote:

I have pgAdmin-III. It has version 1.12.3. I would like to run a job.
I have schedule an SQL Job. But when i run there is no output. Can
anybody let me know what needs to be done?. Also, Can any one tell,
where i need to look for the errors, when i run a job?

by 'job', do you mean run a SQL script file? I'd suggest using psql
for that.

psql -h hostname -d dbname -u username -f scriptfile.sql >outfile.txt

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

On Mon, Sep 24, 2012 at 12:27 PM, John R Pierce <pierce@hogranch.com> wrote:

On 09/23/12 11:24 PM, pavithra wrote:

I have pgAdmin-III. It has version 1.12.3. I would like to run a job. I
have schedule an SQL Job. But when i run there is no output. Can anybody
let me know what needs to be done?. Also, Can any one tell, where i need to
look for the errors, when i run a job?

Hope below link help:

http://www.pgadmin.org/docs/dev/pgagent-jobs.html

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

I have a scheduled a sql query as "select sysdate from dual" and i have given
as "Data Export".

Moreover i cant see the debugger option, or any error log where i can see
it,

Can you tell me any suggestions on this?.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Need-to-run-a-job-in-PgAdmin-III-tp5725093p5725107.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Mandag 24. september 2012 11.06.32 skrev pavithra :

I have a scheduled a sql query as "select sysdate from dual" and i have
given as "Data Export".

That's an Oraclism. Have you actually tested the query in psql?

postgres=> select sysdate from dual;
ERROR: relation "dual" does not exist
LINE 1: select sysdate from dual;
^
postgres=>

Maybe this is what you want?

postgres=> select current_date;
date
------------
2012-09-24
(1 row)

postgres=>

regards, Leif

I dont get my psql console itself disabled in the plug-ins menu.Is there a
way i can see the error log?.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Need-to-run-a-job-in-PgAdmin-III-tp5725093p5725110.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.