I need to process daily and unattended a set of records generated from an
ASP.Net application (framework 1.1), and send out emails accordingly. These
records are stored within a SQL 2000 database and exist for the purpose of
the ASP.Net app.
Right now I'm setting up a SQL job to call a stored procedure that will
xp_cmdshell a .Net console application (within the same soultion as the
ASP.Net app). I set it up this way so I can use the Business and Data Layers
of the ASP.Net app, but it's getting ugly because I cannot access the
Web.config file from the console app.
I'm thinking there has to be a better way to do this. Know of any?