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

Policy Details
Policy Details

You can download sample code from my git hub repository

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.