Re: Sheduler in Postgres

From: Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu>
To: 'Christopher Browne' <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Sheduler in Postgres
Date: 2004-12-11 06:49:49
Message-ID: 0I8J0047UPMX8P@mail.vnet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

OK, thank you. Yes we have a more native tool - the "at" service on NT/2K.

I wanted to boundle it into the application because I don't like to place
parts of the application outside the application. I wrote a scheduler
service sepcialy for the applications tasks. It works fine, but I thought
this should be inside the server.

Thak you,
-- Csaba

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Christopher Browne
Sent: Saturday, December 11, 2004 5:09 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Sheduler in Postgres

The world rejoiced as csegyud(at)vnet(dot)hu (Együd Csaba) wrote:
> Hi, I should schedule the execution of several stored procedures. Now
> I use an NT service for this, but as far as I know e.g. the Oracle has
> such a thing. It would be great if I could fire procedures on a timer
> basis.
>
> Is there a better solution for this than mine?

Traditionally, PostgreSQL has consciously omitted such things where they
would merely be replicating existing operating system functionality.

On Unix, "cron" is the traditional service that provides this functionality.

I think there's a port to Windows NT, so you could presumably use that if
you haven't got any more "native" job scheduler.
--
output = reverse("moc.liamg" "@" "enworbbc")
http://www.ntlug.org/~cbbrowne/lsf.html
"How should I know if it works? That's what beta testers are for. I
only coded it." (Attributed to Linus Torvalds, somewhere in a
posting)

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.805 / Virus Database: 547 - Release Date: 2004.12.03.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.805 / Virus Database: 547 - Release Date: 2004.12.03.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2004-12-11 06:53:04 Re: postgresql and javascript
Previous Message Együd Csaba 2004-12-11 06:44:03 Re: Scheduler in Postgres