Re: Help on pgAgent

On Tue, Jun 4, 2019 at 1:36 PM John G198 <jonathandelatorre98(at)gmail(dot)com>
wrote:

> Yes, I did. But it doesn't run neither, it does update the next run date
> but doesn't actually do anything even the field last run still shows
> nothing. I checked the SQL as I'm trying to update a table column and the
> SQL is correct so I don't what is failing
>
> Please enable logging (Ref: https://www.pgadmin.org/faq/#8) and share
the log file after running the job with Run now.

> El lun., 3 de jun. de 2019 11:59 p. m., Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> escribió:
>
>>
>>
>> On Tue, Jun 4, 2019 at 1:46 AM John G198 <jonathandelatorre98(at)gmail(dot)com>
>> wrote:
>>
>>> Hi im trying to use pgAgent on pgAdmin4 using Windows 10 and i cant see
>>> why but it doesnt work, it doesnt run the jobs created and i just want to
>>> know if it has something to do with my postgreSQL version 11.2 maybe
>>> pgAgent isnt compatible with this version.
>>> So could you let me know whats going on? and what alternative do i
>>> have?, i really need to use Scheduled jobs for this web page db project i
>>> have
>>>
>>
>> Have you tried to run manually via *Run now* option in the context menu
>> of the pgAgent job?
>>
>