On Wed, Sep 12, 2018 at 7:43 AM, jimmy <mpo...@126.com> wrote: > 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, >
Those fields are used for internal tracking, and should not be modified. What are you trying to do exactly? > 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 > ============================================================ > ================================================================ > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
