Re: [ADMIN] Jobs not running

2010-05-22 Thread Tom Lane
Alex Kogan writes: > I also noticed that when I go to Dependencies and Dependents tabs in > pgAdmin3 - I get the "OID out of range" error. Not sure if this is > related to the jobs not running. Below is the error with the statement > from logs. Well, I dunno where that command is coming from, but

[ADMIN] Jobs not running

2010-05-21 Thread Alex Kogan
Hi, RHEL 5.2 x86_64 Postgres 8.3.5 pgAgent3 1.8.4 I noticed that at some point a job I have defined in the agent stopped running. I don't see any related errors in the logs at debug level. The script that the job is supposed to run runs at command line fine. Any ideas on how to troubleshoot this

Re: [ADMIN] Jobs using pgagent

2008-07-16 Thread samantha mahindrakar
2008 13:54:00 -0400 > From: [EMAIL PROTECTED] > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Jobs using pgagent > > > Hi > Iam using postgres since recently.there are jobs scheduled using the > pgagent. There are loaders and stuff that are scheduled using the pgagent

Re: [ADMIN] Jobs using pgagent

2008-07-15 Thread Vishal Arora
Hi, Can you show your event log file? There might be that at different point of time the load on DB is different so it takes some time more than what is expected. -Vishal Date: Tue, 15 Jul 2008 13:54:00 -0400From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [ADMIN] Jobs using pgagent Hi Iam

[ADMIN] Jobs using pgagent

2008-07-15 Thread samantha mahindrakar
Hi Iam using postgres since recently.there are jobs scheduled using the pgagent. There are loaders and stuff that are scheduled using the pgagent. There is a new job that i have addedthe weird part is that it runs for different amounts of time everyday. For example: it has run f

Re: [ADMIN] Jobs

2006-06-27 Thread Jim Nasby
On Jun 27, 2006, at 3:37 AM, Jorge D wrote: I'm trying to use jobs. I installed the service as manual saids but i saw no node on view. Can anybody tell me what i'm doing wrong. Assuming that you're using the job agent that comes with pgAdmin, you'll have better luck asking on their mailing

Re: [ADMIN] Jobs

2006-06-27 Thread Michael Fuhr
On Tue, Jun 27, 2006 at 01:37:53AM -0700, Jorge D wrote: > I'm trying to use jobs. I installed the service as manual saids but > i saw no node on view. Can anybody tell me what i'm doing wrong. What do you mean by "jobs" and "node on view"? What documentation are you looking at and what are you

[ADMIN] Jobs

2006-06-26 Thread Jorge D
Please:   I'm trying to use jobs. I installed the service as manual saids but i saw no node on view. Can anybody tell me what i'm doing wrong.   PD: Sorry, i'm not so good in english.   George      

[ADMIN] Jobs? (schedule tasks)

2004-05-14 Thread Vitaly Belman
Hello pgsql-admin, Are there jobs in PostgreSQL? Or tasks? I saw the pgjobs but it didn't seem active or even finished. If not, how do you implement them externally? I guess one could write some sort of mechanism with PHP and an external scheduler of the OS. Regards, Vitaly Belman