How can I create a PgAgent job creation script? - Mailing list pgsql-general

From Rob Richardson
Subject How can I create a PgAgent job creation script?
Date
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D0168908F@server.rad-con.local
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Paul Taylor
Date:
Subject: Tuning Postgres for single user manipulating large amounts of data
Next
From: Andy Colson
Date:
Subject: Re: Tuning Postgres for single user manipulating large amounts of data