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
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 |