Hello, I need some direction on how to accomplish this task.
I need to execute a stored procedure each night which will check if a client should be billed based on a billing date and todays date. If the client should be billed then take their billing information and execute some .net to process the payment with authorize.net.
I'm using a shared hosting account with a hosting provider and do not have access to the iis server. I can however have the host set up the job on the sql end.
Any advise would be great!
...
Go to the complete details ...