Re: How to stop a scheduled PG_Agent job?

Josh,
I tried to kill the job using task manager. However, ogr2ogr doesn't seem to be a running process. I tried to find the job using "Select * from pg_stat_activity". I can't find the job here either. So, I stopped the pgagent service and restarted postgresql server. Now, in the jobs statistics of the PgAdminIII, the job is still shown to be running.

Ya

-----Original Message-----
From: sfpug-owner(at)postgresql(dot)org [mailto:sfpug-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
Sent: Monday, August 26, 2013 5:09 PM
To: sfpug(at)postgresql(dot)org
Subject: Re: [sfpug] How to stop a scheduled PG_Agent job?

On 08/26/2013 04:13 PM, Wang, Ya wrote:
> Hello All,
> I have a job scheduled using pg_agent, which copies data from MS SQL_SERVER to postgresql table using Ogr2Ogr tools. It is a huge table and it has been two days. Somehow it is still running. I have been trying to kill the job with no success. Restarting the postgresql server or Pg_agent don't do the job.

How have you been trying to kill the job?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com