| Lists: | pgsql-bugs |
|---|
| From: | Rajesh Sundar <Rajeshsundar(dot)Subramanian(at)defiance-tech(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | pgAgent JobScheduler not running jobs |
| Date: | 2010-12-16 06:03:22 |
| Message-ID: | 1292479402510-3307449.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Good morning,
I have installed PostgreSQL 8.3 in my windows XP. I have created a user
named "mowgli".
I created database instances named "dolak" along with the default database
instance ''postgres".
From command line, i ran the pgAgent command as follows:
pgAgent INSTALL pgAgent hostaddr=127.0.0.1 -u <<domain\user>> -p
<<password>> dbname=postgres USER=mowgli -l C:\Program
Files\PostgreSQL\8.3\bin\scheduler.log
I can see a new service named "PostgreSQl Scheduling Agent - pgAgent" and
started it with no errors.
I ran the pgAgent.sql which created a pgAgent catalog under postgres
database. I can also see a new icon named Jobs.
Under Jobs, I created a new job. Once this job is created, i can see of this
job under pga_job table under the catalog created as mentioned above.
The scheduler is not running the job. I dont see any error and no log file
being created.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pgAgent-JobScheduler-not-running-jobs-tp3307449p3307449.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Rajesh Sundar <Rajeshsundar(dot)Subramanian(at)defiance-tech(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: pgAgent JobScheduler not running jobs |
| Date: | 2010-12-27 21:58:57 |
| Message-ID: | AANLkTimMUtncESq7vHvjx2yn+ijhORjYQ1gzNq1hi-SL@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Thu, Dec 16, 2010 at 1:03 AM, Rajesh Sundar
<Rajeshsundar(dot)Subramanian(at)defiance-tech(dot)com> wrote:
> From command line, i ran the pgAgent command as follows:
> pgAgent INSTALL pgAgent hostaddr=127.0.0.1 -u <<domain\user>> -p
> <<password>> dbname=postgres USER=mowgli -l C:\Program
> Files\PostgreSQL\8.3\bin\scheduler.log
The pgAdmin folks also maintain pgAgent. You probably want to report
this bug here:
http://archives.postgresql.org/pgadmin-support/
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company