Search code examples
linuxpostgresqljob-schedulingpgagent

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?

Solution

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

    SELECT * FROM pg_tables WHERE schemaname = 'pgagent';