Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Vishal Arora
From: "Vishal Arora" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] CC: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] PgAgent does not works Date: Tue, 26 Jun 2007 04:17:45 + From: Dave Page <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTE

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Vishal Arora
From: Dave Page <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]> Subject: Re: [pgadmin-support] PgAgent does not works Date: Mon, 25 Jun 2007 13:59:32 +0100 Vishal Arora wrote: I have tried to install the dll using RegSvr32 - it says - "... pgaevent.dll wa

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Vishal Arora wrote: Hi I am sending the event file and dump once again. Sorry for trouble. OK, that looks a little more like I'd expect. So, the event log contains a of messages like: Couldn't create connection: fe_sendauth: no password supplied. (to get rid of the garbage before that, regi

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Khan, Mahmood Ahram wrote: Still not working Assuming thats an error you get when starting pgagent, then I think it's fairly clear what the problem is from the log you posted: Event Type: Failure Audit Event Source: Security Event Category: Logon/Logoff Event ID: 529 Date:

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Vishal Arora wrote: Please find the event log and dump of pgAgent schema. From the dump file, this is the only schedule present: COPY pga_schedule (jscid, jscjobid, jscname, jscdesc, jscenabled, jscstart, jscend, jscminutes, jschours, jscweekdays, jscmonthdays, jscmonths) FROM stdin; 1

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Christophe Chauvet
nks & Best Regards > > M.AHRAM KHAN > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page > Sent: Monday, June 25, 2007 1:17 PM > To: Vishal Arora > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-suppor

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Vishal Arora wrote: pgAgent -u postgres -p hostaddr=127.0.0.1 dbname=postgres user=postgres Hmm, OK - can you please add -l 2 to that to increase the log output, and send me a dump of that from eventviewer once it's run long enough to have missed a job, along with a pg_dump of your pgag

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Vishal Arora
From: Dave Page <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]> CC: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] PgAgent does not works Date: Mon, 25 Jun 2007 10:50:03 +0100 Vishal Arora wrote: There is nothing mentioned in the host agent field. I am

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Vishal Arora wrote: There is nothing mentioned in the host agent field. I am sending the snapshots if you want to have a look at. - vishal Whats your pgagent connection string? Regards, Dave ---(end of broadcast)--- TIP 7: You can help support

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Khan, Mahmood Ahram wrote: I have also tried that. When i create a new job I think some rows should be written to the tables in the pgagent schema. But when I am checking physically the tables there is no data. Is that so due to service of pgagent. pgagent itself doesn't have any effect on the

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Khan, Mahmood Ahram
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page Sent: Monday, June 25, 2007 1:17 PM To: Vishal Arora Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] PgAgent does not works Vishal Arora wrote: > > > >> From: Dave Page <[EMAIL PROTECTED

Re: [pgadmin-support] PgAgent does not works

2007-06-25 Thread Dave Page
Vishal Arora wrote: From: Dave Page <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]> CC: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] PgAgent does not works Date: Sun, 24 Jun 2007 20:46:53 +0100 Vishal Arora wrote: Hi, I want to run some jobs i

Re: [pgadmin-support] PgAgent does not works

2007-06-24 Thread Vishal Arora
From: Dave Page <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]> CC: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] PgAgent does not works Date: Sun, 24 Jun 2007 20:46:53 +0100 Vishal Arora wrote: Hi, I want to run some jobs in postgresql database usin

Re: [pgadmin-support] PgAgent does not works

2007-06-24 Thread Dave Page
Vishal Arora wrote: Hi, I want to run some jobs in postgresql database using pgAgent. I have installed PGAdmin III on my windows XP machine. I tried by scheduling small job like inserting data into a table. The job is created, I ahve scheduled to run every minute but it is not running at

[pgadmin-support] PgAgent does not works

2007-06-23 Thread Vishal Arora
Hi, I want to run some jobs in postgresql database using pgAgent. I have installed PGAdmin III on my windows XP machine. I tried by scheduling small job like inserting data into a table. The job is created, I ahve scheduled to run every minute but it is not running at all. I can not see i