How can I create a PgAgent job creation script?

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How can I create a PgAgent job creation script?
Date: 2010-12-09 14:11:39
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D0168908F@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am preparing an installation disk for a customer. Their installation
includes over ten scheduled jobs. The only way I know of to create a
job is through PGAdmin, using a wizard to enter each piece of
information one screen at a time. I don't want to have to prepare an
instruction document that lists each individual step for creating each
of ten jobs. Is there a way to generate a set of SQL statements for an
existing job as we can for tables, so that all I have to tell the
customer to do is to run a batch file of psql calls to create the jobs?

Thank you very much.

RobR

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-12-09 14:50:50 Re: Tuning Postgres for single user manipulating large amounts of data
Previous Message Vick Khera 2010-12-09 13:32:51 Re: SELECT is immediate but the UPDATE takes forever