Re: Does PostgreSQL support job?

> > > I try to find in the documentation whether PostgreSQL
> supports job,
> > > but I miserably failed. Does PostgreSQL support job? If
> not, what
> > > is the mechanism mostly adopted by PostgreSQL administrators for
> > > running jobs against PostgreSQL? I was thinking about using
> > > cron/plsql/sql-scripts on Linux.
> >
> > The answer really depends on what you mean by "jobs". If
> you have a
> > database task that can be expressed as a series of commands with no
> > interaction involved, you can just put those commands in a file
> > (your-job-
> > name.sql) and run it using psql and cron:
> >
> > # replace leading stars with cron time settings
> > * * * * * psql your-database -i your-job-name.sql
> >
>
> Yes, that's it. A job is a task, i.e. set of statements,
> which is scheduled to run against a RDBMS at periodical
> times. Some RDBMS, such as SQL Server and Oracle, support
> that feature, even if such a feature is managed differently
> from a RDBMS to another.

You could look at pgagent, which comes with pgAdmin3
(http://www.pgadmin.org/docs/1.4/pgagent.html). It does some scheduling
that's a lot more advanced than you get from plain cron. And nice
pgadmin integrated management of course.

//Magnus