Altering and dropping actions

You can alter the config or scheduling parameters with alter_job.

Replace the entire JSON config for job with id 1000 with the specified JSON:

SELECT alter_job(1000, config => '{"hypertable":"metrics"}');

Disable automatic scheduling of the job with id 1000. The job can still be run manually with run_job:

SELECT alter_job(1000, scheduled => false);

Reenable automatic scheduling of the job with id 1000:

SELECT alter_job(1000, scheduled => true);

Delete the job with id 1000 from the automation framework with delete_job:

SELECT delete_job(1000);