Re: Re: how to be related with the schedule and step

2018-09-18 Thread Dave Page
On Tue, Sep 18, 2018 at 1:59 AM, jimmy wrote: > When I checked postgresql's log, I found these error messages.Before that > I didn't do anything. > After finding these errors, I have no idear where it is wrong. > I use postgresql for windows, so I use the jpgAgent. > When I found these errors, I

Re:Re: how to be related with the schedule and step

2018-09-17 Thread jimmy
When I checked postgresql's log, I found these error messages.Before that I didn't do anything. After finding these errors, I have no idear where it is wrong. I use postgresql for windows, so I use the jpgAgent. When I found these errors, I set jobagentid of pgagent.pga_job to 7300. After that I f

Re: how to be related with the schedule and step

2018-09-12 Thread Dave Page
On Wed, Sep 12, 2018 at 7:43 AM, jimmy 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

how to be related with the schedule and step

2018-09-11 Thread jimmy
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