Thread: How can I create a PgAgent job creation script?

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