|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Calling a web page from stored procedureHello,
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 Hi
What is the operation that you would like to perform? -- Show quotebest Regards, Chandra http://chanduas.blogspot.com/ http://www.developersdex.com/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 Show quote "Chandra" <Chan***@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.developersdex.com/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 > > > > > > 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. Show quote "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" <Chan***@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.developersdex.com/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 > > > > > > > > > > > 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 Show quote "JT" <some***@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... > > Chandra, > > > > I'd like to retrieve data from the internet, either in XML or RSS or HTML > > format. > > > > Regards > > > > > > "Chandra" <Chan***@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.developersdex.com/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 > > > > > > > > > > > > > > > > > >  |
|||||||||||||||||||||||
Other interesting topics