Automatic Calculate incentive at last hour after a day by Sql server Scheduler
You can see details of policy of from this image
You can download sample code from my git hub repository
Built on Visual Studio 2013,I have used C# console application with ADO.NET with Sql Server 2014,SqlTransaction, log4net and .NET SMTP mail client to send mail .
I fetch data from a Sql Server database , calculate incentive ,push data to a Schema and log it .In case of failure it automatically rollback ,log the Exception and Send a mail to respective person to look through the matter.