First you create a reminder table here you can insert the records for reminder on Insertion of each record in your master table. The reminders you can call on timer so it will populate.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER Trigger1
ON sales
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
insert into table_2(test1) values(dateadd(day,10,getdate()))
END
GO