How to give notification to customer

[shahnawaz shaikh]

hi,


i want to give notification to customer after every 7 days or monthly through stored procedure or through .net code .