Skip to content
🚀 Agentic Postgres: The first database built for agents 🤖
TimescaleDB - Timeseries database for PostgreSQL Docs
  • tigerdata.com
  • Try for free
Get started
Try the key Tiger Data features
Start coding with Tiger Data
Create a Tiger Cloud service
About Tiger Data products
Tiger Data architecture for real-time analytics
Pricing plans and account management
Feature comparison
Use Tiger Data products
Hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Hypertables and chunks
Hypercore
Continuous aggregates
Data retention
Jobs and automation
add_job
alter_job
delete_job
run_job
UUIDv7 functions
Hyperfunctions
Informational views
Service configuration
Administration Functions
API Reference Tag Overview
Tiger Cloud REST API
Glossary
Compression (Old API, replaced by Hypercore)
Distributed hypertables (Sunsetted v2.14.x)
Import and sync
Integrate AI with Tiger Data
Other deployment options
Find a docs page
TimescaleDB API referenceJobs

delete_job()

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

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

Delete a job registered with the automation framework. This works for jobs as well as policies.

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

Samples

Delete the job with the job id 1000:

SELECT delete_job(1000);

Required arguments

NameTypeDescription
job_idINTEGERTimescaleDB background job id

Keywords

jobsdelete

Found an issue on this page?Report an issue or Edit this page in GitHub.

Previousalter_jobNextrun_job

Related Content

Jobs
TimescaleDB API reference for jobs. Includes SQL functions for adding, altering, deleting, and running a job
add_job()
Add a job to run a function or procedure automatically
run_job()
Manually run a job
alter_job()
Alter a job that is scheduled to run automatically
UUIDv7 functions
Create a hypertable partitioned by time-based UUIDv7
timescaledb_information.jobs
Get information about all jobs registered with the automatic scheduler