Обсуждение: Need to run a job in PgAdmin-III

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?.

---

View this message in context: Need to run a job in PgAdmin-III
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

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: Re: Need to run a job in PgAdmin-III
Sent from the PostgreSQL - general mailing list archive at Nabble.com.