pgAgent setup

From: "Paolo Saudin" <paolo(at)ecometer(dot)it>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgAgent setup
Date: 2005-10-24 18:01:37
Message-ID: 200510241801.j9OI1Vt8011707@wmg1051.eticodns8.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
I've installed the latest PostgreSQL release, 8.1-beta4 with default
settings.
I installed the 'pgagent.sql' script and the service with the following
command :
pgAgent INSTALL pgAgent -u postgres -p postmaster hostaddr=127.0.0.1
dbname=postgres user=postgres

windows user (created during the installation process)
user= postgres
password = postmaster
postgresql user
user=postgres
password=postgres

I run the service with no errors.
I then created a job to fill a table with the current date and time as
follow but it never run and the statistics are empty.
When refreshing, the Next run field does not change

job1
Name job1
Enabled Yes
Host agent localhost
Job class Routine maintenance
Created 24/10/2005 18.44.49
Changed 24/10/2005 18.44.49
Next run 24/10/2005 19.19.00
Last run
Last result Unknown
Running at Not currently running

schedule1
Name schedule1
ID 1
Enabled Yes
Start date 24/10/2005 19.17.00
End date 29/10/2005 0.00.00
Minutes Every minute
Hours Every hour
Weekdays Any day of the week
Monthdays Every day
Months Every months

step1
Name step1
ID 1
Enabled Yes
Kind SQL
Database testdb
Code insert into test values(now());
On error fail

Any idea on what am I doing wrong?

Thanks,
Paolo

Browse pgadmin-support by date

  From Date Subject
Next Message Paul Newman 2005-10-25 05:16:10 Re: Unable to Restore DB
Previous Message Belbin, Peter 2005-10-24 17:23:49 Beta3 schema priveliges problem