[GENERAL] 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: http://postgresql.1045698.n5.nabble.com/Need-to-run-a-job-in-PgAdmin-III-tp5725093.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: [GENERAL] 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 pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need to run a job in PgAdmin-III
On Mon, Sep 24, 2012 at 12:27 PM, John R Pierce pie...@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/
Re: [GENERAL] Need to run a job in PgAdmin-III
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need to run a job in PgAdmin-III
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Need to run a job in PgAdmin-III
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.