Fire ASP page with SQL SP

[Claudio]

I need to call (execute) an asp page in a daily basis automatically.
My idea is to use a Store Procedure. I wrote many sp for update, etc with tables but I don't know how to write one to call an asp page.
Can anybody help me.
Thanks
:confused:

[chrismartz]

What do you mean by Fire Page?

[russell_g_1]

are you sure you actually need to do this? seems like an odd thing to ask...

[Ubik]

You can use scheduled tasks to open i.e. and make your i.e. homepage the asp page you want.

You will need to keep the computer that does this running all the time.

I just use the computer that I have running IIS, but if your asp page is hosted elsewhere, it is not really possible to use your IIS box for this, you will have to have another box for this.

[lmf232s]

I would go with Ubik but i would create a .vbs file that would be executed in stead of an asp page. I assume you just need some SQL queries to fire off and be done with it.