Automatic Calculate incentive at last hour after a day by Sql server Scheduler
Policy summery:
You can see details of policy of from this image
You can download sample code from my git hub repository
incentivePolicy
Technical summery:
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.