Could you all please provide the difference between a scheduled task and basic notification?
We have a requirement to fetch database records from source at regular interval and process it to send to target.
Below is our understanding:
Scheduler service will execute even if the database has no change. Notification will run the service only when there is an action to the table (I/U/D)
Notification connection maintains a single session with the database. Scheduled task will re-establish the connectivity every time the scheduler service runs.
Scheduled task does not support exactly once processing. Notification does.
Notification is more secure as we do not perform any DML on the base table. we only do a SELECT on the based table based on the details provided in the buffer table.
Notifications are built to handle high volume of data as it utilizes UM.
Kindly provide more pros and cons between the 2 approaches.
Thanks & Regards,