Calling a web page from stored procedure

Hello,
Don't know if this is possible.
I have a website on a shared hosting. I can't put any components on the
server,
but I want to schedule a task to run regularly.
My idea was to schedule a stored procedure to run on a regular basis, that
will call
an ASP or ASP.NET page to perform tasks. Is something like this possible?
Are there alternative routes I may take?
ThanksHi
What is the operation that you would like to perform?
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.examnotes.net/gurus/default.asp?p=4223
---
"A_X_L_X" wrote:

> Hello,
> Don't know if this is possible.
> I have a website on a shared hosting. I can't put any components on the
> server,
> but I want to schedule a task to run regularly.
> My idea was to schedule a stored procedure to run on a regular basis, that
> will call
> an ASP or ASP.NET page to perform tasks. Is something like this possible?
> Are there alternative routes I may take?
> Thanks
>
>|||Chandra,
I'd like to retrieve data from the internet, either in XML or RSS or HTML
format.
Regards
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:54EF875B-18B6-4575-8FFC-A35AF441573F@.microsoft.com...
> Hi
> What is the operation that you would like to perform?
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.examnotes.net/gurus/default.asp?p=4223
> ---
>
> "A_X_L_X" wrote:
>
that
possible?|||Would this data be stored in your SQL Server (you mentioned it's your
website)? If so, then contact your ISP and ask for the IP address and port
of the server hosting your database. You can connect via DSN using IP as the
server name, and use DTS to export the data.
"A_X_L_X" <aleksl at aol dot com> wrote in message
news:uCBPDV3VFHA.1148@.tk2msftngp13.phx.gbl...
> Chandra,
> I'd like to retrieve data from the internet, either in XML or RSS or HTML
> format.
> Regards
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:54EF875B-18B6-4575-8FFC-A35AF441573F@.microsoft.com...
the
> that
> possible?
>|||Thanks JT, but no, the data may be not in SQL Server, it maybe just
someone's RSS feed, or a WebService, or a web page.
Here's the structure:
Our Server -- Other Web Server
DB, Webserver - Some data
In General, every other platform but Microsoft's has this feature - like a
Java Servlet, that is actually web-server specific, and can be made to run
on a scheduled interval to pull data from the web and insert into the
database.
I've been programming a Windows Scheduler event in the past, when I had
control over the server, but not in this instance. So the only available
"scheduling" mechanizm is SQL Server jobs. Also, it is possible to make an
external machine do this, and then just send data back to generic "XML
gateway" i.e. to program an ASP / ASP.NET page to accept and parse data and
insert into SQL Server. But this is (a) too long and (b) too error-prone.
Has done this in the past also, even with distributed structure (for
fail-safe), still a maintenance nightmare.
This may not be the right newsgroup to ask, and yet I'm interested in
learning the answer.
Regards
Alex
"JT" <someone@.microsoft.com> wrote in message
news:Ob7QVh7VFHA.3572@.TK2MSFTNGP12.phx.gbl...
> Would this data be stored in your SQL Server (you mentioned it's your
> website)? If so, then contact your ISP and ask for the IP address and port
> of the server hosting your database. You can connect via DSN using IP as
the
> server name, and use DTS to export the data.
> "A_X_L_X" <aleksl at aol dot com> wrote in message
> news:uCBPDV3VFHA.1148@.tk2msftngp13.phx.gbl...
HTML
> the
basis,
>