We're trying to write an app which monitors certain dates in SQL and based on the values of dates/triggers, automatically constructs and fires off email.
Is it possible to load a class into IIS memory and call that logic through either an ASP.Net page or service using a scheduler? The main method in the class could call others which in turn would construct and send any emails.
We were originally thinking about writing an app that can be called from the scheduler but if there is a way to load the logic into IIS and call it through there that would remove at least a step...
I'm totally open to suggestions..
Thanks!