Thread: Help on pgAgent
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
On Tue, Jun 4, 2019 at 1:46 AM John G198 <jonathandelatorre98@gmail.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?
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
El lun., 3 de jun. de 2019 11:59 p. m., Khushboo Vashi <khushboo.vashi@enterprisedb.com> escribió:
On Tue, Jun 4, 2019 at 1:46 AM John G198 <jonathandelatorre98@gmail.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 haveHave you tried to run manually via Run now option in the context menu of the pgAgent job?
On Tue, Jun 4, 2019 at 1:36 PM John G198 <jonathandelatorre98@gmail.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.vashi@enterprisedb.com> escribió:On Tue, Jun 4, 2019 at 1:46 AM John G198 <jonathandelatorre98@gmail.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 haveHave you tried to run manually via Run now option in the context menu of the pgAgent job?