Para listar os próximos jobs, execute a consulta abaixo no banco postgres (ou o banco que tem o pgagent instalado):
| SELECT | |
| pga_job.jobname as job_name, | |
| pga_jobstep.jstdbname as database_name, | |
| pgagent.pga_next_schedule( | |
| pga_schedule.jscid, | |
| pga_schedule.jscstart, | |
| pga_schedule.jscend, | |
| pga_schedule.jscminutes, | |
| pga_schedule.jschours, | |
| pga_schedule.jscweekdays, | |
| pga_schedule.jscmonthdays, | |
| pga_schedule.jscmonths) as next_run | |
| FROM | |
| pgagent.pga_job | |
| JOIN | |
| pgagent.pga_schedule ON pga_schedule.jscjobid = pga_job.jobid | |
| JOIN | |
| pgagent.pga_jobstep ON pga_jobstep.jstjobid = pga_job.jobid; |