Re: How to stop a scheduled PG_Agent job?

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.

If you can point me in the right direction, I would greatly appreciate it.

Thanks,

Ya

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

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

On 08/26/2013 05:16 PM, Wang, Ya wrote:
> 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.

But there's actually no process running?

Probably you'll have to directly update one of the pgagent tables.
Don't know any more than that, I'm afraid.

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

Josh,
Thank you. I also suspect that the jobs statistics may not be accurate. My bigger problem is that I can't restart pgagent service anymore.

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 9:02 PM
To: sfpug(at)postgresql(dot)org
Subject: Re: [sfpug] How to stop a scheduled PG_Agent job?

On 08/26/2013 05:16 PM, Wang, Ya wrote:
> 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.

But there's actually no process running?

Probably you'll have to directly update one of the pgagent tables.
Don't know any more than that, I'm afraid.

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

On 08/26/2013 09:09 PM, Wang, Ya wrote:
> Josh,
> Thank you. I also suspect that the jobs statistics may not be accurate. My bigger problem is that I can't restart pgagent service anymore.

I don't actually use pgagent for anything, so that's as much as I know.

If you're still stuck, try the pgadmin mailing list.

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