run_job()

Manually run a job

Community Since 1.2.0

Run a previously registered in the current session. This works for 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.

Any background worker can be run in the foreground when executed with run_job. You can use this with an increased log level to help debug problems.

Samples

Set log level shown to client to DEBUG1 and run the with the ID 1000:

SET client_min_messages TO DEBUG1;
CALL run_job(1000);

Arguments

The syntax is:

CALL run_job(
    job_id = <job_id>
);

Name	Type	Default	Required	Description
job_id	INTEGER	-	✔	TimescaleDB background ID

Returns

This function returns void.