run_job()
Manually run a job
Community
Since 1.2.0
Run a previously registered job in the current session.
This works for job 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.
Note
Any background worker job 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
Section titled “Samples”Set log level shown to client to DEBUG1 and run the job with the job ID 1000:
SET client_min_messages TO DEBUG1;CALL run_job(1000);Arguments
Section titled “Arguments”The syntax is:
CALL run_job( job_id = <job_id>);| Name | Type | Default | Required | Description |
|---|---|---|---|---|
job_id | INTEGER | - | ✔ | TimescaleDB background job ID |
Returns
Section titled “Returns”This function returns void.