Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

job doesn't fire on schedule time



Hi,
I'm new in *PostgreSQL *and I have to schedule a SQL job that fires every day at 00:00:00. I created the job with its schedule and step (a simple select of a function that checks a field value of a table and send a e-mail). The problem is that the job is fired every 10 sec (the default polling time) and not at the schedule time.
Can you help me?
Thanks.

Teresa Fazio



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group