Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
Install TimescaleDB
Getting started
TimescaleDB
API Reference
Hypertables & chunks
Distributed hypertables
Compression
Continuous aggregates
Data retention
Actions and automation
add_job
alter_job
delete_job
run_job
Hyperfunctions
Informational views
Configuration
Administration Functions
API Reference Tag Overview
Timescale Cloud
Managed Service for TimescaleDB
Promscale
API ReferenceActions and automationdelete_job
Versions:

delete_job()

CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.

Delete a job registered with the automation framework. This works for user-defined actions as well as policies.

If the job is currently running, the process is terminated.

Required arguments

NameTypeDescription
job_idINTEGERTimescaleDB background job id

Sample usage

Delete the job with the job id 1000:

SELECT delete_job(1000);

Found an issue on this page?

Report an issue!

Keywords

jobsdelete
Previousalter_jobNextrun_job

Related Content

User-defined actions
Define your own functions and procedures to run on a schedule
add_job()
Add a job to run a user-defined action automatically
alter_job()
Alter a job that is scheduled to run automatically
run_job()
Manually run a job
timescaledb_information.jobs
Get information about all jobs registered with the automatic scheduler
timescaledb_information.job_stats
Get information and statistics about automatically run jobs