I have multiple pages of dashboard data with sql tables and Fusion charts web parts both connected to a external database.
My challenge is to create an alert on each of these pages so when these tables get updated everymorning , i want sharepoint to send the users an alert. I know alerts can be set for lists and documents but these pages do not have any lists or documents. they are sql tables and charts.
Also i dont want the emails to be sent to everyone but give users an option to opt in like how they can for a normal document.
Any advise would be great!