pg_dbms_job

pig build pkg pg_dbms_job         # 构建 DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

shared_preload_libraries = 'pg_dbms_job';

CREATE EXTENSION pg_dbms_job;

CREATE EXTENSION pg_dbms_job;

pg_dbms_job -c /etc/pg_dbms_job/mydb-dbms_job.conf

BEGIN;
-- 调度作业：每天运行一个过程
CALL dbms_job.submit(
    job       => jobid,
    what      => 'CALL my_procedure();',
    next_date => current_timestamp + interval '1 minute',
    interval  => 'current_timestamp + ''1 day''::interval'
);
COMMIT;

BEGIN;
CALL dbms_job.broken(12345, true);   -- 禁用作业
CALL dbms_job.broken(12345, false);  -- 重新启用作业
COMMIT;

BEGIN;
CALL dbms_job.change(12345, null, null, 'current_timestamp + ''3 days''::interval');
COMMIT;

BEGIN;
CALL dbms_job.interval(12345, 'current_timestamp + ''1 hour''::interval');
COMMIT;

BEGIN;
CALL dbms_job.next_date(12345, current_timestamp + interval '30 minutes');
COMMIT;

BEGIN;
CALL dbms_job.what(12345, 'CALL new_procedure();');
COMMIT;

BEGIN;
CALL dbms_job.remove(12345);
COMMIT;

CALL dbms_job.run(12345);

SELECT * FROM dbms_job.all_jobs;

SELECT * FROM dbms_job.all_scheduler_job_run_details;