pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPgAgent Job Scehduler is NOT running
12+ messages / 2 participants
[nested] [flat]
* PgAgent Job Scehduler is NOT running
@ 2008-11-24 07:51 Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 1 reply; 12+ messages in thread
From: Abdul Rahman @ 2008-11-24 07:51 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-25 06:47 Vishal Arora <aroravishal22@hotmail.com>
parent: Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 1 reply; 12+ messages in thread
From: Vishal Arora @ 2008-11-25 06:47 UTC (permalink / raw)
To: abr_ora@yahoo.com; pgsql-general@postgresql.org; +Cc: pgsql-admin
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 -0800From: abr_ora@yahoo.comSubject: [ADMIN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC: pgsql-admin@postgresql.org
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.
_________________________________________________________________
Register once and play all contests. Increase your scores with bonus credits for logging in daily on MSN.
http://specials.msn.co.in/msncontest/index.aspx=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-25 07:03 Abdul Rahman <abr_ora@yahoo.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Abdul Rahman @ 2008-11-25 07:03 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
No error message appeared. Because statistics is available for the job. It reflects that it is not running.
________________________________
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-25 07:23 Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 1 reply; 12+ messages in thread
From: Abdul Rahman @ 2008-11-25 07:23 UTC (permalink / raw)
To: aroravishal22@hotmail.com; pgsql-admin; +Cc: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-25 10:32 Abdul Rahman <abr_ora@yahoo.com>
parent: Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 1 reply; 12+ messages in thread
From: Abdul Rahman @ 2008-11-25 10:32 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-26 17:25 Vishal Arora <aroravishal22@hotmail.com>
parent: Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 1 reply; 12+ messages in thread
From: Vishal Arora @ 2008-11-26 17:25 UTC (permalink / raw)
To: abr_ora@yahoo.com; pgsql-admin; +Cc: pgsql-general@postgresql.org
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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.comSent: Tuesday, November 25, 2008 3:08:05 PMSubject: 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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.com; pgsql-general@postgresql.orgCc: pgsql-admin@postgresql.orgSent: Tuesday, November 25, 2008 11:47:33 AMSubject: 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 -0800From: abr_ora@yahoo.comSubject: [ADMIN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC: pgsql-admin@postgresql.org
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!
_________________________________________________________________
Searching for the best deals on travel? Visit MSN Travel.
http://in.msn.com/coxandkings=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-27 07:43 Abdul Rahman <abr_ora@yahoo.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Abdul Rahman @ 2008-11-27 07:43 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-27 12:27 Vishal Arora <aroravishal22@hotmail.com>
parent: Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 2 replies; 12+ messages in thread
From: Vishal Arora @ 2008-11-27 12:27 UTC (permalink / raw)
To: abr_ora@yahoo.com; pgsql-admin; +Cc: pgsql-general@postgresql.org
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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.com; pgsql-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Wednesday, November 26, 2008 10:25:11 PMSubject: 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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.comSent: Tuesday, November 25, 2008 3:08:05 PMSubject: 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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.com; pgsql-general@postgresql.orgCc: pgsql-admin@postgresql.orgSent: Tuesday, November 25, 2008 11:47:33 AMSubject: 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 -0800From: abr_ora@yahoo.comSubject: [ADMIN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC: pgsql-admin@postgresql.org
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!
_________________________________________________________________
Register once and play all contests. Increase your scores with bonus credits for logging in daily on MSN.
http://specials.msn.co.in/msncontest/index.aspx=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-28 05:12 Abdul Rahman <abr_ora@yahoo.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Abdul Rahman @ 2008-11-28 05:12 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
I searched but didn't find any pgpass.conf file.
________________________________
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-28 05:57 Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 0 replies; 12+ messages in thread
From: Abdul Rahman @ 2008-11-28 05:57 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
I have found via cmd prompt. My Computer (GUI) is not showing the path and file (pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in this file.
----- Forwarded Message ----
From: Abdul Rahman <abr_ora@yahoo.com>
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Friday, November 28, 2008 10:12:23 AM
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
I searched but didn't find any pgpass.conf file.
________________________________
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-28 10:11 Abdul Rahman <abr_ora@yahoo.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
1 sibling, 0 replies; 12+ messages in thread
From: Abdul Rahman @ 2008-11-28 10:11 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; pgsql-admin; +Cc: pgsql-general@postgresql.org
That's it!
Arora your document (http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than the best. The error was of postgress user rights and nothing else. After granting rights to postgres Its really running well.
Thanks.
________________________________
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com; pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
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@hotmail.com>
To: abr_ora@yahoo.com
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@yahoo.com
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
To: aroravishal22@hotmail.com; pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running.
----- Forwarded Message ----
From: Vishal Arora <aroravishal22@hotmail.com>
To: abr_ora@yahoo.com; pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
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@yahoo.com
Subject: [ADMIN] PgAgent Job Scehduler is NOT running
To: pgsql-general@postgresql.org
CC: pgsql-admin@postgresql.org
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!
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: PgAgent Job Scehduler is NOT running
@ 2008-11-28 16:46 Vishal Arora <aroravishal22@hotmail.com>
parent: Abdul Rahman <abr_ora@yahoo.com>
0 siblings, 0 replies; 12+ messages in thread
From: Vishal Arora @ 2008-11-28 16:46 UTC (permalink / raw)
To: abr_ora@yahoo.com; pgsql-admin; +Cc: pgsql-general@postgresql.org
Its located in Application Data folder.
Date: Thu, 27 Nov 2008 21:12:23 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
I searched but didn't find any pgpass.conf file.
From: Vishal Arora <aroravishal22@hotmail.com>To: abr_ora@yahoo.com; pgsql-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Thursday, November 27, 2008 5:27:26 PMSubject: RE: [ADMIN] PgAgent Job Scehduler is NOT running
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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.com; pgsql-admin@postgresql.orgCc: pgsql-general@postgresql.orgSent: Wednesday, November 26, 2008 10:25:11 PMSubject: 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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.comSent: Tuesday, November 25, 2008 3:08:05 PMSubject: 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 -0800From: abr_ora@yahoo.comSubject: Re: [ADMIN] PgAgent Job Scehduler is NOT runningTo: aroravishal22@hotmail.com; pgsql-admin@postgresql.orgCC: pgsql-general@postgresql.org
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@hotmail.com>To: abr_ora@yahoo.com; pgsql-general@postgresql.orgCc: pgsql-admin@postgresql.orgSent: Tuesday, November 25, 2008 11:47:33 AMSubject: 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 -0800From: abr_ora@yahoo.comSubject: [ADMIN] PgAgent Job Scehduler is NOT runningTo: pgsql-general@postgresql.orgCC: pgsql-admin@postgresql.org
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!
_________________________________________________________________
Search for videos of Bollywood, Hollywood, Mollywood and every other wood, only on Live.com
http://www.live.com/?scope=video&form=MICOAL=
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2008-11-28 16:46 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-24 07:51 PgAgent Job Scehduler is NOT running Abdul Rahman <abr_ora@yahoo.com>
2008-11-25 06:47 ` Vishal Arora <aroravishal22@hotmail.com>
2008-11-25 07:03 ` Abdul Rahman <abr_ora@yahoo.com>
2008-11-25 07:23 Re: PgAgent Job Scehduler is NOT running Abdul Rahman <abr_ora@yahoo.com>
2008-11-25 10:32 ` Abdul Rahman <abr_ora@yahoo.com>
2008-11-26 17:25 ` Vishal Arora <aroravishal22@hotmail.com>
2008-11-27 07:43 ` Abdul Rahman <abr_ora@yahoo.com>
2008-11-27 12:27 ` Vishal Arora <aroravishal22@hotmail.com>
2008-11-28 05:12 ` Abdul Rahman <abr_ora@yahoo.com>
2008-11-28 16:46 ` Vishal Arora <aroravishal22@hotmail.com>
2008-11-28 10:11 ` Abdul Rahman <abr_ora@yahoo.com>
2008-11-28 05:57 Re: PgAgent Job Scehduler is NOT running Abdul Rahman <abr_ora@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox