Scheduling a JDBC Polling Notification


I currently have a very simple JDBC polling notification on a SQL table looking for inserts. It is scheduled to poll every 60 seconds.

However, we now have a requirement to execute this at 11pm every night. Not every 60 seconds. I could set the polling to check every 24 hours, and start the job at 11pm but that is not a great way of working.

Any ideas?

Many many thanks,

Allan Martin

One approach that might work is to establish a scheduled task that runs at 11 that enables the notification. Then, schedule another task that runs at 11:10, 11:15, whatever, to disable the notification.