postgresqlpgagent

PgAgent jobs not executing on remote server

I don't understand why this isn't working, I set up a pgAgent job to send a NOTIFY from the database every hour

enter image description here

The steps

enter image description here

The schedule

enter image description here

Solution

  • Turns out that problem was that heroku doesn't support agAgent and the database was running on heroku, I ended making a work around the scheduling tasks using windows task scheduler - it's not the best solution but it does the job I needed to do...