pgagent

pig repo add pgdg -u    # add pgdg repo and update cache

pig install pgagent;		# install via package name, for the active PG version

pig install pgagent -v 18;   # install for PG 18
pig install pgagent -v 17;   # install for PG 17
pig install pgagent -v 16;   # install for PG 16
pig install pgagent -v 15;   # install for PG 15
pig install pgagent -v 14;   # install for PG 14

CREATE EXTENSION pgagent;

-- View all jobs
SELECT jobid, jobname, jobenabled, jobdesc
FROM pgagent.pga_job;

-- View job steps
SELECT jstid, jstjobid, jstname, jstenabled, jstkind, jstcode
FROM pgagent.pga_jobstep;

-- View job schedules
SELECT jscid, jscjobid, jscname, jscenabled,
       jscstart, jscend, jscminutes, jschours,
       jscweekdays, jscmonthdays, jscmonths
FROM pgagent.pga_schedule;

-- View job execution log
SELECT * FROM pgagent.pga_joblog
WHERE jlgjobid = 1 ORDER BY jlgstart DESC;

-- View step execution log
SELECT * FROM pgagent.pga_jobsteplog
WHERE jsljlgid IN (SELECT jlgid FROM pgagent.pga_joblog WHERE jlgjobid = 1)
ORDER BY jslstart DESC;