Re: Job scheduling in Postgre

am Thu, dem 04.12.2008, um 16:40:38 +0000 mailte Dave Page folgendes:
> >> There is a database level schedular called (iirc) pgAgent, which comes bundled
> >> with pgAdmin. I think it's so well hidden because it comes as a part of a
> >
> > How does it work? Independent from the OS? On the server, within
> > PostgreSQL?
>
> It runs as a service on Windows or daemon on *nix, and connects to a
> pgagent schema in a database which may or may not be on the same
> machine.
>
> You can define jobs using pgAdmin (the definitions of which are stored
> in the database) which consist of one or more SQL or batch/shell
> steps. A job can be targetted at a particular server, so you can
> ensure batch steps run on a Windows box, and shell on a unix, or can
> be run by the first (or only) pgAgent instance that picks it up. SQL
> steps currently target a specific database, and in future releases
> will be able to target databases on alternate servers - a feature
> required for use with hot standby servers.

Thx for the explanation.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net