Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Call a Web Site page from Job or Stored proc

Author  Topic 

netzorro
Starting Member

6 Posts

Posted - 2009-09-18 : 13:41:00
Hi, I've got a problem. I'm developing a asp.net web site using sqlserver 2005.
I need a way to run a special web page to run a process ever hour.
I need a way to call this special aspx page.
I was wondering if it is possible to call a web page from a sqlserver job I can schedule.

I cannot write a different application to run the procedure because the web site will be hosted on some shared computer (I cannot afford a dedicated hosting server).

Is there a way to use sqlserver to do this? I only have to start a web page and that's all.

Any other ideas?

Thanks for your help
Diego

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-09-18 : 17:52:22
If its a shared server, there is not much you can do, cause they dont allow custom scripts.

But you can use the XMLHTTP request object in extended SP to call the page, based on a job or service broker.


comprende ???
Go to Top of Page
   

- Advertisement -