[Bug] different channels in notify and listen

[cwang9208]

When a scheduled job is submitted, there will be a trigger to notify the daemon using the channel "dbms_job_scheduled_notify" (

pg_dbms_job/sql/pg_dbms_job--1.5.0.sql

Line 350 in 4d6884c

PERFORM pg_notify('dbms_job_scheduled_notify', TG_OP || ':' || NEW.job);

). However, the daemon listens to a topic named "dbms_job_cache_invalidate" (

pg_dbms_job/bin/pg_dbms_job

Line 697 in 4d6884c

$ldbh->do("LISTEN dbms_job_cache_invalidate");

), and can thus not receive the notification on time.