Console command to launch web method?

[Guest]

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?

 

[Guest]

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?

I think a web service is what I'm looking for.