How can I create a PgAgent job creation script?

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема How can I create a PgAgent job creation script?
Дата
Msg-id 04A6DB42D2BA534FAC77B90562A6A03D0168908F@server.rad-con.local
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Paul Taylor
Дата:
Сообщение: Tuning Postgres for single user manipulating large amounts of data
Следующее
От: Andy Colson
Дата:
Сообщение: Re: Tuning Postgres for single user manipulating large amounts of data