Search Postgresql Archives

Re: [ADMIN] PgAgent Job Scehduler is NOT running

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Well in that case you need to check if you have relevant entries in pgpass.conf file.


Date: Wed, 26 Nov 2008 23:43:25 -0800
From: abr_ora@xxxxxxxxx
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@xxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
CC: pgsql-general@xxxxxxxxxxxxxx

Thanks Vishal,

I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error:

could not open the file "D:\xxx.backup":Permission denied.

I tried to perform the task from both (normal & postgres) users of OS. But no benefit.


From: Vishal Arora <aroravishal22@xxxxxxxxxxx>
To: abr_ora@xxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
Sent: Wednesday, November 26, 2008 10:25:11 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Try to follow the steps given in following link -
 
http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc


Date: Tue, 25 Nov 2008 02:32:46 -0800
From: abr_ora@xxxxxxxxx
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@xxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
CC: pgsql-general@xxxxxxxxxxxxxx


Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working .


From: Vishal Arora <aroravishal22@xxxxxxxxxxx>
To: abr_ora@xxxxxxxxx
Sent: Tuesday, November 25, 2008 3:08:05 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

Is the service running properly, try to schedule a new job and see the results.


Date: Mon, 24 Nov 2008 23:23:15 -0800
From: abr_ora@xxxxxxxxx
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@xxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
CC: pgsql-general@xxxxxxxxxxxxxx

No error message appeared. Because NO statistics is available for the job. It reflects that it is not running.


----- Forwarded Message ----
From: Vishal Arora <aroravishal22@xxxxxxxxxxx>
To: abr_ora@xxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx
Cc: pgsql-admin@xxxxxxxxxxxxxx
Sent: Tuesday, November 25, 2008 11:47:33 AM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running

What is the error message you are getting. What is the interval you have set for scheduling the job.


Date: Sun, 23 Nov 2008 23:51:46 -0800
From: abr_ora@xxxxxxxxx
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@xxxxxxxxxxxxxx
CC: pgsql-admin@xxxxxxxxxxxxxx

Dear all,

I  installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result.

Regards,
Abdul Rehman.



Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!



Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!



Free up your senses. Experience reality up close on MSN video Try it!



Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux