SQL Server configuration

1. Make sure that you have configured SQLServerAgent to start automatically when your SQL Server starts. You can check this from the Control Panel | Services, look for SQLServerAgent.
   
   
2. RODOPI comes with a scheduled task RODOPI Daily Billing . You must enable it if it is not enabled from  Management / SQL Server Agent / Jobs in the SQL Enterprise Manager. By default the task will be enabled so you don't need to do this manually.
   
   
3. The Daily Billing task maintains an internal billing date. It is incremented by 1 day each time the task has run successfully. The task will not run more than once for the same billing date. Also it will not run for future dates. The Daily Billing task will be scheduled by default to run at midnight. You can change the scheduled time from the SQL Enterprise Manager.
   
   
   IMPORTANT!!! If for some reason the Daily Billing task is not running you will have some billing days missing. The reason for this can be that the SQLServerAgent service is not running or the scheduled task RODOPI Daily Billing is not enabled or the task is failed (you will see the reason in the history of the scheduled task). Indicator that the Daily Billing task was not running can be that there are no rows in the statements of the new customers. Also there will be no automatic credit card charges and no reoccurring charges will be calculated.
   To correct this you need to run the task RODOPI Daily Billing once for every missing day. If you need to run this task more than once (you missed more than one day of billing) you need to run the task , wait until it finished and check the history (status). If successful run it again. Do NOT run two instances of the task at the same time, because double billing can occur. When you receive message in the history: "Invalid Billing time" this means that the billing date is correct and the task will not start for future dates.