I use pgAgent 3.4 in pgAdmin 4 to create a job. In this job I create a schedule
and a step.
I query the table pga_job, pga_jobagent, I find pga_job.jobagentid is null.
That means it is not related with this schedule and step.
How to operate that it will be related with the pga_job.jobagentid and
pga_jobagent.jagpid,
this is the error logs:
========================================================================================================================
2018-09-12 11:00:06 HKT [7300]: [1-1] user=postgres,db=postgres,app=jpgAgent:
WIN-IL4VKOA9EAB,client=127.0.0.1 ERROR: insert or update on table "pga_job"
violates foreign key constraint "pga_job_jobagentid_fkey"
2018-09-12 11:00:06 HKT [7300]: [2-1] user=postgres,db=postgres,app=jpgAgent:
WIN-IL4VKOA9EAB,client=127.0.0.1 DETAIL: Key (jobagentid)=(7300) is not
present in table "pga_jobagent".
2018-09-12 11:00:06 HKT [7300]: [3-1] user=postgres,db=postgres,app=jpgAgent:
WIN-IL4VKOA9EAB,client=127.0.0.1 STATEMENT: UPDATE pgagent.pga_job SET
jobagentid=$1, joblastrun=now() WHERE jobenabled AND jobagentid IS NULL AND
jobnextrun <= now() AND (jobhostagent = '' OR jobhostagent = $2) RETURNING
jobid, jobname, jobdesc
============================================================================================================================
