run_job() Community

Run a previously registered job in the current session. This works for user-defined actions as well as policies. Since run_job is implemented as stored procedure it cannot be executed inside a SELECT query but has to be executed with CALL.

TIP:Any background worker job can be run in foreground when executed with run_job. This can be useful to debug problems when combined with increased log level.

Required Arguments

NameDescription
job_id(INTEGER) TimescaleDB background job id

Sample Usage

  1. SET client_min_messages TO DEBUG1;
  2. CALL run_job(1000);

Set log level shown to client to DEBUG1 and run the job with the job id 1000.