I have .net class from SMS Service provider which i am using in my vb.net application to send individual sms to patients. The class has method ( sendsms) which accepts relevent parameters and sends the sms thro the service provider gateway.
Now the requirement is auto sending of bulk sms (outstanding payment) to patients at predefined time. this i feel can be achieved easily if i can call this method from sql server stored procedure. (.net stored procedure in sql)
Request expert help on this.