Amazon Simple Notification Service (SNS) is designed to send notifications immediately. There are no functions for scheduling notifications in SNS.
Amazon Simple Queue Service (SQS) has a delay function, but only up to 15 minutes - this is useful if you need to do some work before processing a message, for example, copying related data to Amazon S3.
Given that you need to schedule a notification for some future time. you need to implement server-side logic, for example, polling a database at a fixed fixed time interval OR something like a task scheduler .
source
share