Re: How to stop a scheduled PG_Agent job?

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