CODEWITHSUNDEEP
linuxpostgresqljob-schedulingpgagent
Nurjan
Nurjan

Reputation: 6053

Setting a job schedule for pgagent in linux through command line

I cannot set a job schedule for pgagent in linux shell. However, I can do that in pgAdmin GUI, but not in command line. Has anybody ever done that in linux command line?

Upvotes: 2

Views: 3649

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127056

It's an INSERT or UPDATE on the postgres-database, in schema pgagent.

SELECT * FROM pg_tables WHERE schemaname = 'pgagent';

Upvotes: 3

Related Questions